Page 1 of 1
Posted: Thu Jul 12, 2018 12:55 pm
by qt_ky
One approach is to use a string function first to strip all white space then use another string function like AlNum() to checks whether the given string contains only alphanumeric characters or not.
Posted: Thu Jul 12, 2018 1:38 pm
by ray.wurlod
Step 1: sort out your data provider(s).
Step 2: use the "double Convert()" technique to preserve only wanted characters.
Code: Select all
Convert(inLink.TheString, Convert(inLink.theString, wantedchars, ""), "")
Posted: Fri Jul 13, 2018 2:15 pm
by UCDI
to just remove the records entirely you can do it with a single convert, or possibly even more efficiently with 'alpha' if that fits the data need? A single convert, you convert all the valid chars to nothing and then check the length of the remainder.
double convert fixes the data, which is a different thing from "remove these records from further processing"