Help with a regular expression

[cfisher440]

Say I have a line of text like this

11/12/06, 71,00589331,00200,00227755,00210,00058889,00017

I want to split this line up so that I have variables for all the values separated by commas.
In other words I want 11/12/06 to have it's own variable, 71 to have its own variable, 00589331 to have it's own variable, and so on.

Any ideas would be appreciated

 

[JohnH]

Use the String.Split function, example this in your string variable Temp then: Temp.Split(",") will return the array of these strings

 

[cfisher440]

Thanks

Thanks, that will work.

One more question I forgot to put in there: How do I test to see if a line is blank?

I want to loop through a bunch of lines, reading them in and parsing them. I want to do it until it comes to a blank line. (do until ?)

 

[JohnH]

Check if string is just about empty "" - that is two double quotes without any characters inside, not even a space.