asp how to split a csv file when an apostrophe is present
Posted on 2007-10-21
Does anyone know how to load a csv file that has apostrophies? I'm trying to upload and process a csv file and I can't think of a way around this? Here's what I have..
Set oInStream = objFSO.OpenTextFile("HostImport.csv", 1, false)
Do Until oInStream.AtEndOfStream
i = i + 1
sLine = oInStream.readLine
strValue = Split( sLine, ", " )
If Not IsNull(strValue(0)) OR Not IsEmpty(strValue(0)) Then
<insert the line>
Howerver in the data I have:
94884, "John", "Smith", "Smith, John"