Replace(,)(.)

Hey Team
I am using for loop in datatable
I have column in which(,)and(.) is available so i have to remove
I want to replace (. to ,) and (, whoch is used as sepreator I want only space place of ,)
In one line statement

1 Like

Hi @Kuldeep_Pandey

Just use a for each row datatable and then an assign activity

row("YourColumnName") = row("YourColumnName").ToString().Replace(".", ",").Replace(",", " ")

Regards

Hello @Kuldeep_Pandey ,
Try this

= CurrentRow("ColumnName").ToString.Replace(",", " ").Replace(".", ",")

image

1 Like

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