On 2 November 2001 12:20, Daryoush Ashtari [mailto:[EMAIL PROTECTED]] wrote: > Can some one tell me how I can find a substring in specific field of > records of a database in PostgreSQL with Perl?
I would suggest substring, either in SQL (SUBSTRING(field FROM start FOR char-count)), or, having got the data into Perl, Perl's substr function (substr expr, offset, length). To get the data from the database into Perl, the best way is probably DBI (which I've not used much so I won't try to put an example together, but look back at this lists archives and you should find plenty of examples). Richard Cox Senior Software Developer Dell Technology Online All opinions and statements mine and do not in any way (unless expressly stated) imply anything at all on behalf of my employer -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]