CSV parsing

[prmanningham]

Hi guys, I've tried a few UDFs to help me achieve my goal but I unfortunately didn't suceed yet.

I don't know if one of you has an easy solution for the goal I'm trying to achieve.

Here's what I'm trying to do :

I have a csv of 1191 lines with 3 values on each lines separated by ";"

I would like to separate each value and process each line in a loop.

Thanks in advance for the help.

[BrewManNH]

We're going to need more information than that. what do you mean when you say "I would like to separate each value and process each line in a loop."? Explain what it is you're trying to do with each line, what you're trying to do with each value that you're separating in the line. I'd start by looking at FileRead, or _FileReadToArray, or FileReadline and then use StringSplit on the lines of the file.

[prmanningham]

Sorry for not providing enough details.

First value is workstation name, second is the path to file I'm trying to process and third is the username

The script needs to check if local workstation name = value1. If positive copy value2 to a network share while renaming the file to value3-%time%.pst and so on for each line.

Thanks for pointing me to StringSplit. This seems to be what I was looking for

[jdelaney]

This will work:

#include <Array.au3>
$string = "test1,test2,test3" & @crlf & "test4,test5,test6" & @CRLF & "test7,test8,test9"
$atest = StringRegExp( $string, "(.*),(.*),(.*)", 4)
_ArrayDisplay ( $atest )
For $i=0 To UBound ( $atest ) - 1
 _ArrayDisplay ( $atest[$i] )
Next

replace the string with the file's text

[water]

To read/write a CSV file to/from an array you could use this UDF.

[czardas]

Water, the link seems to be broken.

prmanningham, I have been using my UDF for a while now without ever experiencing problems. ProgAndy has also written a you might like to try. There are one or two small differences.

Edited September 7, 2012 by czardas

[water]

I checked the link. one works.

[prmanningham]

thanks all!

I tried this and I keep getting an error saying : "Array variable has incorrect number of subscripts or subscript dimension range exceeded."

Shoud this be displaying each line of my CSV?

#include <array.au3>
#include <CSV.au3>

$rc = _ParseCSV("c:testpst.csv", ";")

For $i = 0 To UBound($rc)
    _ArrayDisplay($rc[$i])
    ; You can now use the array as necessary
Next

[water]

Try

_ArrayDisplay($rc)

_ArrayDisplay is able to display 1D and 2D arrays.

[jdelaney]

You would only need to loop through the array if it were an array of arrays, like in my example. Yours is considered a 2D array.

Also, you should use the upper limit as UBound()-1, when it is a legit loop you need to do.

[czardas]

EDITED OUT (oops I just saw what the problem was - answered by water)

jdelaney, I don't think using an array of arrays is more suitable. It is recommended that you avoid doing this.

prmanningham, you need to subtract 1 if you use ubound to loop through the rows.

For $i = 0 To UBound($rc) -1 ; Subtract 1

If you want to loop through the columns, you need a second loop inside the first loop. No time to demonstrate right now, but someone will help you further, I'm sure.

Edited September 7, 2012 by czardas

[jdelaney]

It's an autoit function that produces it

[czardas]

It's an autoit function that produces it

I see. You're forgiven.

[prmanningham]

Awesome guys, I've been able to finish my script with your help!

Thanks a lot!