Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mstelmac

    Incrementing problem (I'm missing something here)

    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...
  2. mstelmac

    Incrementing problem (I'm missing something here)

    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"...
  3. mstelmac

    Populate variable with piece of string?

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

    Populate variable with piece of string?

    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...
  5. mstelmac

    Basic variable question - Thanks in advance.

    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...
  6. mstelmac

    Sorting a string

    Thats a great idea. Thanks, Matt
  7. mstelmac

    Sorting a string

    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...
  8. mstelmac

    Records repeat 1 time in details section

    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...
  9. mstelmac

    Records repeat 1 time in details section

    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...
  10. mstelmac

    Substitution question

    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...
  11. mstelmac

    Substitution question

    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
  12. mstelmac

    Substitution question

    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...
  13. mstelmac

    Simple sort question

    Thank you very much guys.
  14. mstelmac

    Simple sort question

    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...
  15. mstelmac

    Perl/ClearQuest Multiple record issue with 2 tables

    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...
  16. mstelmac

    JList question

    Thats a great idea. Thank you very much for your help. -Matt
  17. mstelmac

    JList question

    Hello everyone. Can anyone give me a hint on how to underline the values in a Jlist? I was thinking of writing a renderer (if it's possible) but wanted to see if anyone had a better idea. v/r, Matt
  18. mstelmac

    Wrap cell contents in quotes

    Thank you very much, that works great! -Matt
  19. mstelmac

    Wrap cell contents in quotes

    Hello everyone. I hope everyone is enjoying the holiday season and not stuck in work like myself. I have an excel sheet in which I want to wrap the contents of every cell in quotes. Example: 12345 Defect Severe Matt Johnson Would look like this: "12345" "Defect" "Severe" "Matt Johnson"...
  20. mstelmac

    CR10 field data not displaying

    Hello everyone. I just upgraded to CR10 from CR8.5 and two of my fields are not displaying on any of my formats. Both fields are just short strings.....nothing fancy. I did a verify database but that did not help. I also removed them and re-added them. Does anyone have a suggestion...

Part and Inventory Search

Back
Top