Hi,

I'm trying to create a script that reads from a csv file. I then want the text from each column to be split in two. this is the code I've created so far (maybe this explains a bit more)

Code:
 
IF Open(3,"C:\helpdesk\kix\la.csv") = 0
$x = ReadLine(3)
WHILE @ERROR = 0
$Value = Split($x,",")
For Each $Element In $Value
? $Element
Next
$x = ReadLine(3)
LOOP
Close (3)
ELSE
BEEP
? "Cannot open file, error code: [" + @ERROR + "] + " " "@SERROR""
ENDIF



The la.csv file exists of two columns with value's that belong together. How can I split these values? example:
$ElementPart1 $ElementPart2

regards,

Jeroen