String Search & Replace?

John Hemmer hemmerjohn at hotmail.com
Thu Nov 4 06:56:42 PST 2004


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

John



More information about the Filepro-list mailing list