How to update particular column of csv

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