How to replace a cell data in a csv file

[ElPandaRojo1]

I need to know how I can replace a specific cell in a CSV file

 

Example:

I have 10 data in my file

Shoe
Bed
Table
Chair
Dinning room
Television
Washing machine
Computer
Stove
Door

I need to replace the table with a bucket. How I do this?

Thanks for the help

[Jos]

What have you tried and are having issues with?  

Jos

[ElPandaRojo1]

I have tried this code and it also tries StringRegExpReplace but it doesn't work

#include <File.au3>

Local $datos = FileOpen (@UserProfileDir&"\Desktop\ChatsActivos.csv");, $FO_APPEND)
    $informacionLeida = FileRead($datos)
    $filasArrary = StringSplit($informacionLeida,@CR,2)
    $NumberActive = StringSplit($filasArrary[$s],";",2)
    FileWrite($NumberActive[0][1],$vActual&";"&$gActual)
    FileClose($datos)

Compartir.au3

Edited April 4, 2020 by Jos

[Jos]

Just to get you started, something like this should be close:

$Input = FileRead(@UserProfileDir&"\Desktop\ChatsActivos.csv")
FileWrite(@UserProfileDir&"\Desktop\ChatsActivos-new.csv",StringRegExpReplace($Input,"table","bucket"))

Change the Regex in case you need to refine the replace search.

Edited April 4, 2020 by Jos

[ElPandaRojo1]

Thank you very much, if it works for me, I appreciate it