DSXchange

Hi,

Please let me know if we have any stage in Datastage 8.1 to remove unwanted character from file and move data further for processing.

regards,
Sachin.

Hi Sachin,

For column data:Transformer convert function
For entire file :unix sed command

--------------
Sreeni

If you are getting the character in file. You can even use trim command in unix and delete it. Sed, Awk commands will help if you need to replace it.

How about more specifics around what "unwanted character" might mean?

There is ctrl M character in file, which i can remove using unix script, but wanted to remove using stage if any available.

Use Convert() function in Transformer stage, as noted.

If the file is fixed width you could change the definition of the final column to be one character smaller, then define a new, Char(1) column that contains the Ctrl-M, and use the "drop on import" property for that column.

Or, of course, you could use tr -d '\r' or similar as the Filter Command in a Sequential File stage.

At the end of each line or buried within data fields? For the former, read it as a DOS file.