String Search & Replace?

[Jean-Pierre A. Radley]

John Hemmer propounded (on Thu, Nov 04, 2004 at 09:56:42AM -0500):
| 
| ----- Original Message ----- 
| From: "Tim Fischer" <tim.fischer at trinitytransport.com>
| To: "'filePro mailing list'" <filepro-list at seaslug.org>
| Sent: Thursday, November 04, 2004 9:19 AM
| Subject: String Search & Replace?
| 
| 
| > I'm running into an issue where I need to take all the "'s out of a string
| > and replace them with \".  It needs to be entirely dynamic as I don't know
| > where in the string the "'s will be.
| >
| > I've checked the xlate statement, but it looks like I can only do single
| > character replacement (is this true?) which wouldn't work as I need to
| > escape the quote.
| >
| > Obviously, I could use the mid() statement in a huge loop, but with the
| > amount of fields - and the size of fields, I'd end up taking too large of
| a
| > performance hit.
| >
| > Any ideas?
| >
| > Tim Fischer
| 
| Hi Tim,
| 
| If you are running on a 'nix system you could use unix sed command on the
| filePro key file.

You absolutely could not!

The sed command operates on text files, with lines terminated by a new
line.  That does not describe a filePro key file.

-- 
JP