String Search & Replace?
Tim Fischer
tim.fischer at trinitytransport.com
Thu Nov 4 08:00:43 PST 2004
> i reread your message and now understand - you want to replace
> a " with a \" - e.g. from 1 to 2 characters - xlate will not do
> that and i don't know of a simple function that will - after all,
> it requires some judgement as to what to do if lets say because of
> adding on characters the string no longer fits into the allotted
> length.
>
> you could make a complicated loop with mid, as you suggest, and
> also making sure that it is only run once, as you can guess what
> will happen with each pass on the same data.
>
> i don't think you can do it with an edit as filepro reserves the
> double-quotes for its own use in edits (and hacking this from outside
> fp's define edits, the running will result in seg-v or dos/win equiv)
>
> --- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
> -Joe Chasan- Magnatech Business Systems, Inc.
> joe at magnatechonline.com Hicksville, NY - USA
> http://www.MagnatechOnline.com Tel.(516) 931-4444/Fax.(516) 931-1264
Thanks Joe,
Marc Brumlik actually gave me few lines of code that will take care of the
issue for me. (Thanks Marc!!!)
Since I'm not running this to change the data in the actual fields (I'm only
running it as part of a data transfer) I don't have to worry about running
out of room (just make the dummy variable a few characters longer than the
real variable) and I don't have to worry about re-running it (yes, that
would cause a rather large mess).
Thanks again for all your help!
Tim Fischer
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
More information about the Filepro-list
mailing list