Splitting with comma

[Cyberskull]

Hey guys,

I need to do a split in an old app we've got running and it's in classic ASP. We're importing some stuff into a database and running through a report file.

The report file is comma delimited. Now here is the problem I've got:

Date Range,"Jul 14, 2010"

This get's split by the comma but it splits the date up as well. Now we do have the "" around the date. Is there a way to tell Split or use a different function to ignore splitting anything that is inside a ""

Thanks for your help.

[Pradeep1210]

Use Regular Expressions.

[His Nibbs]

Use Split, then concatenate the date parts:
parts = Split(yourString,",")
theDate = parts(1) & parts(2)

Use string functions if you need to remove the quotes from theDate string.