edits: the quotes thing...
John Esak
john at valar.com
Thu Sep 1 07:39:28 PDT 2005
I don't know why I'm going to put my neck out there on the chopping block...
I, too, think this can't be done in an edit. You want to remove quotes....
huh? Well, the only possible way I can think to do this *might* be as
follows. Create your own complex edit which is a series of lines that
describe every single character in the ASCII set which you WILL allow in the
field.... and then use that as the edit type. Of course, the " would not be
one of the specified allowed characters.
Since you can't specify a " as a character within "'s as in """ or the "\""
that you tried, maybe doing it by *omission* is the only way. I haven't
tried this, because I don't want to do something as tedious as this. I once
wrote an edit that took away all punctuation and spaces... and it was enough
of a painful tedium to make me not want to do that again. (It, by the way,
is an example in the filePro Survivor Series CD's).
Now, there is only one drawback (well there may be many others, but this is
a big one). You could not use this edit on data that already exists,
because you would not be providing any rules for what to do if a " was found
in already existing data. You could only use this on empty fields which
*people* would be entering data into.... A process might throw it in there
and there would be an error. At least with manually entered *people* that is
data, they would *see* the error and be able to fix it.
You see why I didn't want to expose all of this (and my neck) to the cutting
crews?
john
More information about the Filepro-list
mailing list