CSV data extraction

[LlamaNoHat]

Hi,

If you have a csv file with a handful of rows, is it possible to write an ahk that reads the first row, extracts only the needed data (For example, only words from cells in columns C and E) and then repeats this onto the next row, but if the C column contains a specific word, it skips that one row altogether?
I imagine after the data extraction it would append a new csv with the filtered out data and then would generate separate descriptions for each row of data collected in a text file.

I checked the CSV library but every time I try to use any of the libraries available for ACH it always pops errors for me ALWAYS, and I keep deleting various unneeded lines to avoid errors but nothing ever works...

[mikeyww]

I don't see why not. Reading some of the documentation may help you. Example

[rommmcek]

Maybe your CSV is Tab separated.

Spoiler

Code: Select all

FileRead, csvVar, csvFile.csv ; or: C:\Path\csvFile.csv   if csv isn't in the same dir

Loop, Parse, csvVar, `n, `r
    if ( (csvLine:= StrSplit(A_LoopField, "`t")).3 != "SpecificWord" )
        csvExtract.= csvLine.3 "`t" csvLine.5 "`n" ; append columns C & E
        
MsgBox % csvExtract

[flyingDman]

@LlamaNoHat if you post you code, you're more likely someone will help you.