Removing junk character from a field in modify stage

[Sagnik Mukherjee]

Hi,
I got junk characters(like small small boxes) in one field. I am using modify stage and in this stage I handled null for that field.
Ex - AMEX_REV_CMNT_TX:string[max=100] = handle_null(AMEX_REV_CMNT_TX,"")
where AMEX_REV_CMNT_TX is the field name.
But still the issue is not resolved.

I assume that the junk characters are ascii characters.
Now can we remove ascii characters from a field?? Is there any syntax??
Or anyone have any other solution removing the junk characters from modify stage??

Thanks..

[ArndW]

Those "junk" characters are indeed non-displayable characters in your current language set / representation. Are you certain that you really wish to remove these characters from the text/comment fields; perhaps the data will later be read by someone who does have the correct NLS settings and who might wish to read those words.

If you still need to remove these characters then using a transform stage might be necessary, as I cannot offhand think of a modify stage function that will do this for you.

Essentially you will need to replace all characters with ASCII values below your lowest valid visible character as well as those with ASCII values above your highest valid visible character (using single-byte LATIN-1 representation).