Convert a numeric value which has '.' into ',' for the whole column in a csv file

For a given column in the CSV file, how to convert ‘.’ into ‘,
The replace the dot with the comma

Ex:
If the column is called ‘num’ and contains the first value as ‘7.5’, can we convert it into ‘7,5’?

Hi @ray_sha

Use row(“ColumnName”).ToString.replace(".",",")

Thanks
Ashwin S

in the assign activity?

yes

Thanks
Ashwin S

Hey @AshwinS2
It worked.
Thanks!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.