How to remove control characters from source data
Posted: Sun Mar 27, 2005 8:07 pm
Hi,
I am running a DataStage Server job, it is failing at the record where there are control characters.
Earlier when I figured out the Line Feed control characters I used Exchange Function in Transformer Stage and could resolve the problem by replacing it with a space.
Exchange(InputData,'Oa','20')
But now in my data there are other control characters which I am not able to figure out which control character it is.
I could search the same in vi editor by giving the following search pattern : /\\$
Please tell me which control character it is and how should I handle the same in Transformer stage.
Thanks in advance
Regards
Anand
I am running a DataStage Server job, it is failing at the record where there are control characters.
Earlier when I figured out the Line Feed control characters I used Exchange Function in Transformer Stage and could resolve the problem by replacing it with a space.
Exchange(InputData,'Oa','20')
But now in my data there are other control characters which I am not able to figure out which control character it is.
I could search the same in vi editor by giving the following search pattern : /\\$
Please tell me which control character it is and how should I handle the same in Transformer stage.
Thanks in advance
Regards
Anand