Change all values of column

Hi
I have n rows and one of column have values like 2,000 3,000 4,000 etc I just want to replace those values

@KarthikBallary What do u want to replace those vlaues with ?

remove only","

HI @KarthikBallary

Loop through your datatable using a for each row activity. Inside the loop, use an assign activity and do the replace as follows

row(“ColumnName”) = row(“ColumnName”).ToString.Replace(",", “”)

Once done, you can use the new values where ever you need.

1 Like

this will throw syntax error

What’s the syntax error you are getting? I tested this and it works fine for me…

1 Like

refrence index cannot end with expression

Ok I got it. Thank you. minor mistake

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