Getting data from comma-delimited file...

[tim]

I have a text file with comma-delimited data in it. I read the file in ASP with FileSystemObject and I want to extract the data in the second field (the one after the first comma).

Example:

Item1, Customer1, Price1, Date1
Item2, Customer2, Price2, Date2
Item3, Customer1, Price3, Date3

How can I do that?

[paul]

Hi Tim,

You can use the Split VBScript function to get and array of values for each line in your text file. The VBScript Split function separates a string into substrings and puts those substrings into one-dimensional array where each substring is an element.

The VBScript Split function takes 2 parameters, the first one is the string you want to split, the second one is your delimiter string (comma in your case). You can omit the delimiter parameter when calling the Split function and in this case the delimiter will be the default one - single empty space.

Remember that the result of Split VBScript function execution is zero-based array, so the second item on your line will be arrTextFileLine(1)

In your case you need to do the following:

[tim]

Thanks Paul,

You almost wrote a full VBScript Split article here .

It's highly appreciate it!



Tim