How do I find garbage/control characters within a column?

mohanraj · Post by **mohanraj** » Wed Mar 26, 2008 2:56 am

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)

ray.wurlod · Post by **ray.wurlod** » Wed Mar 26, 2008 3:07 am

Code: Select all

Len(Oconv(Oconv(InLink.TheInput,"MC/A"),"MC/N")) > 0

One Oconv() removes all alphabetic characters, the other removes all numeric characters. Anything left over is non alphanumeric.

chulett · Post by **chulett** » Wed Mar 26, 2008 7:25 am

balajisr · Post by **balajisr** » Wed Mar 26, 2008 7:37 am

dinthat · Post by **dinthat** » Wed Mar 26, 2008 7:46 am

DSguru2B · Post by **DSguru2B** » Wed Mar 26, 2008 9:19 am

What was the question again. Why would anyone get a reply with the code and then clear the question

gateleys · Post by **gateleys** » Wed Mar 26, 2008 9:42 am

DSguru2B wrote:What was the question again. Why would anyone get a reply with the code and then clear the question

Unwillingness on the OP's part to recognize the fact that he/she had to take help for a "trivial" matter, perhaps!!!!

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 · Post by **gateleys** » Wed Mar 26, 2008 12:13 pm

Thanks Administrator.... for updating the OP's initial post (which he had deleted after he got an answer), and the 'subject' item (which he had put as 'g').

And someone else has to clean up the mess!!!

ray.wurlod · Post by **ray.wurlod** » Wed Mar 26, 2008 2:53 pm

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.