Hello , @balupad14 @indra I want to change one column from csv . In CSV there is a column called as review that contains (3.4 ,3.8,4.1*) i want to update them as (3.4,3.8,4.1)
Hi @ImPratham45,
1.Use the Read CSV activity and stored the data into a datatable.
2.Create a string variable called strValue.
3.Use the assign activity to store the value to the variable like strValue= dtTables.Rows(0).Item(0).tostring
4.Again use the assign activity strValue=strValue.Replace(“*”,“”).
5.use the assign activity dtTables.Rows(0).Item(0)=strValue
6. Write the data to a csv by Write CSV.
Regards
Balamruugan
Thank you sir!!! I will notify you once it works
Sure… I hope your Academy study is going well…
Regards
Balamurugan.
The solution is working on a single row
so I think i need to use counter is it ryt?
Its working…Ty @balupad14
1 Like