xlate question
Mike Schwartz-PC Support & Services
mschw at athenet.net
Fri Jan 21 05:34:48 PST 2005
> On Behalf Of Kenneth Brody
> > rep(15)=xlate(15,chr("34")chr("44")," ")
> > and that had reported a error, so count that out, I however did not
> > try with a & inbetween, that sounds like it would work but I never
> > ended up needing it.
> [...]
>
> It reported an error because you need something to join the chr("34")
> and chr("44"), such as '&'.
>
> However, if the problem with commas [for which you could have used ","
> rather than chr("34")] was because you didn't have quotes around the
> field, then placing quotes around the field would eliminate the need
> to eliminate the commas.
I think you meant to say "used "," rather than chr("44")", Ken, or am I
not reading something correctly?
Actually what would be the correct (or best) syntax for replacing
two characters within a field using just one xlate command? Suppose we
wanted to replace the double quotes with a period and the commas with a
tilde. Would this work:
rep(15)=xlate(15,chr("34")&","),".~")
I've never used xlate with multiple characters, and this might be
something that everybody on the list should add to their arsenal of filePro
knowledge...
Thanks!
Mike Schwartz
More information about the Filepro-list
mailing list