CSV Search AutoIT
CSV Search AutoIT I have a CSV file that contains 4 columns, I want to search column 2 and change the corresponding data in column 4 using AutoIT: col 1 col 2 col 3 col 4 1 502 shop 25.00 2 106 house 50.00 3 307 boat 15.00 2 Answers 2 If the columns are separated by tabs then you could use StringSplit for that. $s1 = '1 502 shop 25.00' $s2 = '2 106 house 50.00' $s3 = '3 307 boat 15.00' For $i=1 To 3 $array = StringSplit(Eval('s' & $i), @TAB) ConsoleWrite('Column 2: "' & StringStripWS($array[2], 8) & '"' & @CRLF) ConsoleWrite('Column 4: "' & StringStripWS($array[4], 8) & '"' & @CRLF) Next This sample code will print: Column 2: "502" Column 4: "25.00" Column 2: "106" Column 4: "50.00" Col...