Change all values of column

Help
, ,
1

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

2

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

3

remove only","

4

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
5

this will throw syntax error

6

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

1 Like
7

refrence index cannot end with expression

error
error1346Ă—86 28 KB

8

Ok I got it. Thank you. minor mistake

9

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