Update Csv file

[Tim_p]

Hi all I’m trying to update a single value in a csv file I wish to change the value of one column from a 1 to 2

I can find the correct row using

 dim lines() as string = io.file.readalllines("csv.txt")
for x as integer = 0 to lines.getupperbound(0)
    if lines(x).contains(Id) then
        lines(x) = lines(x).replace(Id , "Value4")
    end if
next
 
io.file.writealllines("csv.txt", lines)

But this updates the actual Id I need to step through to the 17th column and change that entry

[.paul.]

Try this...

dim lines() as string = io.file.readalllines("csv.txt")
for x as integer = 0 to lines.getupperbound(0)
    if lines(x).contains(Id) then
        Dim fields() as string = lines(x).Split(","c)
        fields(17) = "Value4"
        lines(x) = String.Join(",", fields)
        Exit For
    end if
next
 
io.file.writealllines("csv.txt", lines)

Although, the 17th column will be fields(16)...

[Tim_p]

Worked like a charm
Thanks