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 Chriss Miller 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. not4google

    Variable Question

    Hi all, I have a Stored Proc I am trying to optimise. Theres a select statement in there which puts a value into a variable which is then used further down in the SProcedure. What I want to do is pre-run this stage so add a value to a variable and then be able to run the Stored Proc which...
  2. not4google

    Debugging Stored Procedure - TimeStamp

    Currently I have the following which seems pretty useful: SET STATISTICS TIME ON --Code here SET STATISTICS TIME OFF
  3. not4google

    Debugging Stored Procedure - TimeStamp

    Hi all, I have a huge Stored Proc (T-SQL) that I need to get some information on. I want to put in print statements at specific points of the procedure to get back the timestamp, How can I get the timestamps of specific points? GETDATE()? Thanks for any suggestions,
  4. not4google

    Simple RegEx problem

    Hi all, Sorry ignore this thread the above is working fine I had another condition in there which was preventing this from working correctly, Cheers,
  5. not4google

    Simple RegEx problem

    Hi all, I am trying to match the following: $text = "abcdef-TO"; if($text =~ /-TO/){ #do something here } This doesnt seem to work, something to do with the "-" as in "-TO"? I have tried escaping it but no joy, any help much appreciated, Cheers,
  6. not4google

    Creati ng new HashArray from 2 existing Hashes

    Hi Thanks for the response, If you could explain this line in a bit more detail that would be really useful as Im new to Perl, Thanks,
  7. not4google

    Creati ng new HashArray from 2 existing Hashes

    Hi all, I have 2 HashArrays: %a %b %a contains the following key/value pairs: Forward/Value %b contains the following key/value pairs: Curve/Forward What I need to do is create a new HashArray that is a combination of %a and %b and has the following key/value: Curve/Value Any assistance...
  8. not4google

    Joining 2 Hash Arrays

    Hi could someone tell me if its possible to join 2 hash arrays together in Perl? Thanks,
  9. not4google

    Printing Specific String from File - Following match

    The line in the source file is: abc,def,ghi,klm,HELLO_TEST,xyz The following identifies that this line contains _TEST in one of the fields. grep {/_TEST/} @commArray Once its been identified that the line contains _TEST all I need to do is print out the word on the line that contains...
  10. not4google

    Printing Specific String from File - Following match

    Thanks for the suggestions, The above suggestion matches the lines with _INDEX but then I need to get the word on that line (which in the following example is HELLO_TEST) and print that out, e.g. if the line contains: abc,def,ghi,klm,HELLO_TEST,xyz I need to identify that this line contains...
  11. not4google

    Printing Specific String from File - Following match

    Hi, Currently I am doing the following: open (COMMFILE,"<$commfile") || perror ( "Could not open $commfile for input\n"); @commArray = <COMMFILE>; #Loop through the file to get list of the allowed comm types foreach $commElem (@commArray) { @allowedCommodities = split(/,/, $commElem)...
  12. not4google

    Printing Specific String from File - Following match

    Hi all, I have a csv file which is comma seperated and around 500mb. The string that I am searching on is _INDEX" in the file and what I need to do is find this string and then print out the full word that contains _INDEX. The issue is that the word _INDEX may not occur in the same place on...
  13. not4google

    Perl Array - Unique

    Hi all, I have an array which muliple values in it and what I wanted to do is add the 5th element of the array to a new array which only stores unique values. I would normally do this in shell scripting but wanted to learn some Perl so any suggestions would be much appreciated, Thanks,
  14. not4google

    Simple Looping Issue?

    Thanks for the quick response, I dont think Ive explained the issue properly. Once I get to the line matched qwerty1 what I want to do is force Perl to go to the next line untill I get to a line natching qwerty2, Help is much appreciated,
  15. not4google

    Simple Looping Issue?

    Hi all, I have some data that Im working on: ,qwerty1,data1,data2,data3 ,,,,,,,,,,,,,,,,,,,2005 ,,,,,,,,,,,,,,,,,,,2006 ,,,,,,,,,,,,,,,,,,,2007 ,qwerty2,data1,data2,data3 ,,,,,,,,,,,,,,,,,,,2008 ,,,,,,,,,,,,,,,,,,,2009 ,,,,,,,,,,,,,,,,,,,2010 In my code I want to get to the point where I...

Part and Inventory Search

Back
Top