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

Help
, , ,
1

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’?

2

Hi @ray_sha

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

Thanks
Ashwin S

3

in the assign activity?

4

yes

Thanks
Ashwin S

5

Hey @AshwinS2
It worked.
Thanks!

6

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