How do I find garbage/control characters within a column?
Moderators: chulett, rschirm, roy
How do I find garbage/control characters within a column?
In a Server job I wish to ensure that there are no garbage characters in the field. How would I do that?
(Item modified by the Administrator)
(Item modified by the Administrator)
Last edited by mohanraj on Wed Mar 26, 2008 4:53 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Len(Oconv(Oconv(InLink.TheInput,"MC/A"),"MC/N")) > 0
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.
Unwillingness on the OP's part to recognize the fact that he/she had to take help for a "trivial" matter, perhaps!!!!DSguru2B wrote:What was the question again. Why would anyone get a reply with the code and then clear the question
Its this kind of attitude that annoys me. When all of us are here to exchange knowledge, there are some that get what they want from here, but are unwilling to share it with the rest of the forum community. Further, the choice of the subject name 'g' shows the OPs intention.
gateleys
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you replace "garbage" with "non-alphanumeric" you pretty much have the original question - how to remove non-alphanumeric characters from a string.
A later reply from the OP indicated that he (she?) would try what I suggested.
That the thread is marked as resolved suggests that it works.
A later reply from the OP indicated that he (she?) would try what I suggested.
That the thread is marked as resolved suggests that it works.
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.