iOS Question LoadCSV issue with certain characters.

[RVP]

I am finding that some characters can cause an issue using loadCSV, for example / in a text field will cause the parse to fail. Is there a list of characters that should not be in fields?

 

[Erel]

How are you creating the CSV file? Make sure that it is encoded with UTF8.

 

[RVP]

I am getting the data thru Application_OpenUrl and save it like this:

Dim strUtil As StringUtils
File.WriteString(File.DirTemp,"Light.csv",csv)

csv is the string I received

 

[RVP]

This is the data I am receiving:

Do Not remove any columns or rows.  Do not change the format of any cells.  The first line must have the Vendor Information. Start on Line 4.,,,,,,,,,,,,,,,,
Vendor,VendorName,SalesContact,SalesPhone,SalesEmail,TechnicalContact,TecnhicalPhone,TechnicalEMail,WebSite,Notes,Address,Model,Type,CandelaFlood,CandelaSpot,CandelaMid,Notes
Required every row,Required Once on First row of new Vendor,Required Once,Required Once,Required Once,Required Once,Required Once,Required Once,Required Once,Required Once,Required Once,Required every row,Required every row,if Applicable,if Applicable,if Applicable,if Applicable
Ianiro,Ianiro,,,,,,,,,,Solaris,"2KW, Tungsten Fresnel",26952,334867,,
Ianiro,,,,,,,,,,,Solaris,"1KW, Tungsten Fresnel",11600,117000,,
Ianiro,,,,,,,,,,,Solaris,"650W, Tungsten Fresnel",9000,80600,,
Ianiro,,,,,,,,,,,Solaris,"300W, Tungsten Fresnel",4100,18200,,
Ianiro,,,,,,,,,,,Solaris,"150W, Tungsten Fresnel",2000,9000,,
Ianiro,,,,,,,,,,,Blonde,"2KW, Tungsten Open Face",23958,98010,,
Ianiro,,,,,,,,,,,Redhead,"1KW, Tungsten Open Face",12300,41000,,
Ianiro,,,,,,,,,,,Redhead,"650W, Tungsten Open Face",9500,33300,,

What seems to be happening, is it is not interpreting the data as separate lines, it seems to thing this is one line. Looking at the file which is being opened, it has a CR at th end of the line where-as a file that works has CRLF. I am guessin the difference is that one was created on a Mac, and the other on a Windows machine.

 

[Erel]

LoadCSV works with two types of end of lines:
Chr(10) - \n
or
Chr(13) & Chr(10) - \r\n

If your CSV string uses \r as the end of line character then you should replace it:

File.WriteString(File.DirTemp,"Light.csv",csv.Replace(Chr(13), Chr(10))