DSXchange

How do I scrub control characters from data using DataStage. I've tried using the convert function in a transformer with no luck.

Data looks something like this: ^Hgooddata^C^H

Nielsek,

I will probably do using some unix commands like "tr - d" or :%s/.^H//g if the source file is a sequential file. Search for Control Characters and you will find some interesting threads in this forum.

Hi,
You can use sed command

Hi,
You can use "sed" command OR you can use "Oconv" function in the basic transformer.To know more do a search.

How do I scrub control characters from data using DataStage. I've tried using the convert function in a transformer with no luck.

Data looks something like this: ^Hgooddata^C^H

You should be able to use the Convert() function. ^C is Char(3), ^H is Ctrl(8). Construct a list of control characters in a stage variable, and use Convert() to replace that with "".