using an Array

[shornw]

Hi all

is it possible to read a comma seperated file to an array so that each item becomes a seperate array column. I have a .txt file which is written when users logon to the domain, below is a typical line:

SmithF, PC1234, Fred Smith, Finance, 1234

JonesB, PC3456, Bill Jones, Sales, 7890

What I want to do is read this line into an array so that each item is read into a seperate column. If I use _FileReadToArray every item on each line is written into one single column.

Sorry if this is obvious

Thanks for looking

[Melba23]

shornw,

Do it in 2 steps within an outer loop:

- 1. Use StringSplit to get the next single line into a 1D array.

- 2. Use an inner loop to read the elements from that 1D array into the correct elements of the final 2D array.

M23

[JohnOne]

#include <Array.au3> ;just to show array

$sString = "SmithF, PC1234, Fred Smith, Finance, 1234"

$atemp = StringSplit($sString,",",2)

Local $aArray[1][UBound($atemp)]
For $i = 0 to UBound($atemp) -1
    $aArray[0][$i] = $atemp[$i]
Next
$atemp = 0

_ArrayDisplay($aArray)

I'm in a jovial mood today.

Edited July 14, 2010 by JohnOne

[Juvigy]

I was curious , so ..

include <Array.au3> ;just to show array

$sString = "SmithF, PC1234, Fred Smith, Finance, 1234,Test2, PC1235, Test 2, Germany, 1235"
$atemp = StringSplit($sString,",",2)
Local $aArray[1][5]
$i=0
$b=0
Do
    For $j = 0 to 4
        $aArray[$b][$j] = $atemp[$i]
        $i=$i+1
    Next
    ReDim $aArray[UBound($aArray)+1][5]
    $b=$b+1
Until $i>UBound($atemp)-1
_ArrayDisplay($aArray,$i)

[shornw]

Thanks for your replies, very helpful.

I hit a wall in another pway now. My thinking went this way:

$sString = "SmithF, PC1234, Fred Smith, Finance, 1234"

$split = StringSplit($sString, ",")

If $split[1] = @UserName And $split[2] = @ComputerName Then Exit

Can anyone tell me why, although $split[1] returns the username and $split[2] returns the PC name the If/Then will not work.

Thanks again

[JohnOne]

Nope, works fine for me.

[Mat]

Is that a bit of space I see after the commas?

[shornw]

Mat...... can you come and shoot me. That much stupidity doesn't deserve to live!!!

Thank you, this is the last bit of a huge data collection script which needs to be completed by Friday...and I have to leave at 12 tomorrow.

REALLY much appreciated.

I love this forum

[Mat]

Mat...... can you come and shoot me. That much stupidity doesn't deserve to live!!!

You'll only really find bugs like that when you know what you're looking for to start with. The good news is that you won't make that mistake again, so you can only be shot once