filewritetoarray csv, but with commas in the location

[MrCheese]

hi all,

reviewing the forum, this thread is applicable: 

 

 

I wanted to know if there is now a better way to do this?

In essence, I load a tab delimited txt file into an array (works well). I used tab, as some fields in the original csv contains commas.

However, I needed autoit to manipulate this array, and output it as a csv.

IF my array contains items with a comma, without double quotes around the field, then how best do I get a csv out of this?

My current workaround is to filewritefromarray tab delimited, then open it in excel and save as a csv. I will need to check this to see how the address fields behave that contain a comma.

 

Any thoughts would be appreciated.

 

[FrancescoDiMuro]

@MrCheese
A very raw solution:

Global $strTabFile = @ScriptDir & "\Tab.txt", _
       $strCSVFile = @ScriptDir & "\CSVFile.csv", _
       $arrFileContent


_FileReadToArray($strTabFile, $arrFileContent, $FRTA_NOCOUNT, @TAB)
_ArrayDisplay($arrFileContent, "Before formatting:")
FormatCSV($arrFileContent)
_ArrayDisplay($arrFileContent, "After formatting:")
_FileWriteFromArray($strCSVFile, $arrFileContent, Default, Default, ",")


Func FormatCSV(ByRef $arrArray)

    For $i = 0 To UBound($arrArray) - 1 Step 1
        For $j = 0 To UBound($arrArray, $UBOUND_COLUMNS) - 1 Step 1
            $arrArray[$i][$j] = '"' & $arrArray[$i][$j] & '"'
        Next
    Next

EndFunc

 

Edited October 15, 2018 by FrancescoDiMuro

[water]

I use the CSV.au3 written by ProgAnd:

 

[MrCheese]

Thanks @FrancescoDiMuro

and thanks @water

so i see that my problem that I need to attend to first is initially loading it.

I need to load it correctly as a CSV, so I can export it accordingly.

The CSV.au3 that you've linked to does everything perfectly; I've kept my current import process (as its scripted out of sql already), and just utilised this as an export. Thanks 

 

Edited October 15, 2018 by MrCheese

[water]