DSXchange

How to remove delimiter (;) from the end of a csv file , when the csv file is a source. I need to do for a field in a transfrormation in order to remove the delimiter at the end.

If the ";" is also a field delimiter then you can either add a dummy "FILLER" field to your column definitions or you can use the "filter" in your sequential stage to remove that trailing semicolon from you data stream using something like "sed 's/[ ;]*$//'"

Due to the fact that I am using only one transformation stage , is it possible to use the 'replace' or something else in order to remove the delimiter

You can also tell DataStage on the Sequential File Stage what exactly your row delimiter is.
For example RecordDelimiterString=;\n

Could you explain your problem a bit more - is the semicolon actually your field delimiter character and is this character being placed in the last column?

Hi ,


try using Trim(column,";","T") in transformer stage.


This will remove the last occurrence of ";".