Remove thousand separator in csv file

dataservices job design
1

Hi

Have a scenario where I need to remove the thousand separator and have only decimal separator as dot

Data received from source : 3,222.05
Expected output in csv file : 3222.05 and datatype should be double or any numeric datatype but not varchar

Please suggest the way through this

Thanks in Advance

bianalyst-bods (BOB member since 2016-08-26)

2

Hi,

In this case the incoming number is probably a varchar right?
you can use the to_decimal function to convert this to a decimal where you can set what the DecimalSperator is and what the ThousandsSeperator is.
Then simply have a CSV target and configure the format of this target field in the flatfile format. If this field was already incoming as a decimal you only have to set the format you want in the flatfile.

SvenStrater (BOB member since 2015-08-26)