Recent content by mstelmac

Kevin197, I'm using a SQL Server database and your exactly right (DOH). Has nothing to do with the perl script that increments the value....it's the SQL max command Im using. When searching for strings the value "whatever_9" will always be the max to "whatever_10 or 11, or 12". Dang.....now...

hello everyone, I have the following code that works flawlessly except doe not count higher that 10. When it reaches 10 it just keeps repeating 10. I am using the code to assign unique numbers and store them in a database field. $sw_version = "3.1.1"; $asset_name = "ShipName"...

Thank you both very much. I was going down the wrong path and using a substr command. This is very useful. thanks again. -Matt

Hello everyone. Can anyone tell me the best way to populate a variable with a piece of a string. I need to capture all of the text after the last under score. my $string = "3.0.0_SWNAME_48" I'm really just trying to populate a variable with the number 48. Problem is 48 could really be 480...

Hello everyone. I am having one heck of a time doing something very simple in perl. I am trying to set a variable (named $test) to this value: "email.address1\@yahoo.com", "email.address2\@yahoo.com" Then I am using the variable as part of this SMTP call: $smtp->to($test); Here is my code...

Thats a great idea. Thanks, Matt

CR developer version 10 Clearquest version 2003.06.15 MS SQL Server 2000 Hello everyone, I have a report format that prints a list of change request records. Unfortunately all data is pushed into CR as strings. Can anyone help me sort the CR field? My current output looks like this: CR115...

Wow, you got all that from my little post.....lol. The field "id" located in my users report header is being used for grouping. I am using Crystal version 10, SQL server 2000 as our backend, Clearquest version 2003.06.15 which generates the result set and forwards it to the Crystal runtime...

This is not going to be easy to explain but here goes. For some reason if the records in my details section runs over 1 page into say 2 or 3 pages the records repeat 1 time. This is weird. I already have the ID of the record in the details section set to suppress if duplicated. The only...

Michael, My perl program is run over a large text file. It's purpose is to remove any character founf within quotes that may mess up getting it into excel. For some reason excel does not like these characters in their cells even though that are wrapped in quotes. So I tried this line...

Hmm I tried both of these methods and I still see new paragraph markers in my file within quotes. I opened the file in MS word and still see these characters that look like a backwards P. If these exist with quotes then I can not import into excel. thanks, Matt

Hello everyone. I have been reading about string substitution but do not understand how to find my pattern. My pattern only exists in quotes like this: $variable = "The Dog Can Run"<tab>"The Dog Can Swim"<carriage return> I need to remove any new line, tab, carriage return, basically any...

Thank you very much guys.

Hello everyone, does anyone know the easiest way to sort (ascending) a variable that contains the values: c001 c002 c004 c003 The values are delimited by whatever is needed, currently it is by space. Im learning that in VB script I can not just push them into an Array and use a "sort" command...

First off, thanks for looking, and if you feel this should be in another area please let me know, thanks. I have two tables(DB's) Shown below. These are within ClearQuest V. 2003.06....... I would like to place a perl hook into the field Labeled Table2_Text on Table2. What I want to happen is...