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.
Remove unwanted character from file using any stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Mon Jul 09, 2012 6:51 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.