DSXchange

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)

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

h?

i.

j

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

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.

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!!!

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.