Re^2: strip text from a string

Hi,

This isn't a homework assignment, I'm trying to strip out column values in various SQL statements, that have been outputted to a log file. The example given was a trivial example to simplify the request, I have a perl script that pulls the statements into a .csv file, so that I can then group the statements together and write indexes based on the SQL.

The SQL is produced from code, so will always call the same columns in the same order so as long as I strip out the data held in the columns I can work out what indexes are needed.

I only started to use perl on Monday, I'll have a look at the perldocs. It's a case of on the job learning.

Thanks

Comment on Re^2: strip text from a string

Replies are listed 'Best First'.
Re^3: strip text from a string by kennethk (Abbot) on Sep 11, 2014 at 17:48 UTC
I'm sorry I misidentified your post. Usually, spare questions of this form fall into this category. What materials are you using for reference? There are some great free materials out there, and finding them early can greatly expedite the learning process. Familiarity with the Perl documentation is probably one of the most important skills to develop in Perl. More often than not, it's the search engine associated with my Firefox search box. Learning how to navigate CPAN and comfort with hashes and complex data structures are way up there as well. Some references you may consider perusing: http://learn.perl.org/, in particular http://learn.perl.org/books/ Best Practices(TM) reference card course notes offered by Perl Training Australia http://perl.apache.org/docs/general/perl_reference/perl_reference.html #11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.	[reply]
Re^4: strip text from a string by KalaMonkey (Initiate) on Sep 12, 2014 at 09:44 UTC
Hi, Thanks for the list of resources, usually I have more time to learn new skills, unfortunately for me the need to use perl came late in the day and the deadline is today. I will use the list provided for future reference, there's no point letting it go to waste. Thanks	[reply]
Re^3: strip text from a string by GrandFather (Saint) on Sep 11, 2014 at 21:11 UTC
In addition to kennethk's list of resources I strongly recommend getting a copy of the Perl Pocket Reference.^* ^* It must be good, this is the second time I've made the recommendation in as many days (and I'm not the author or on commission). Perl is the programming world's equivalent of English	[reply]