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