Handling Junk Characters
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Step 1: sort out your data provider(s).
Step 2: use the "double Convert()" technique to preserve only wanted characters.
Step 2: use the "double Convert()" technique to preserve only wanted characters.
Code: Select all
Convert(inLink.TheString, Convert(inLink.theString, wantedchars, ""), "")
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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"
double convert fixes the data, which is a different thing from "remove these records from further processing"