"read spreadsheet file" & "excel get data" get different results (bug?)

[DNF小号]

I want to get data from .csv file, but find a problem & hope someone can tell me the reason.

There are some "double quotation marks" in csv file. for example：

Castlenet;"CastlenetSAS603";"2N38024000001";" 

I read the csv file with "read speadsheet file" function  but get an abnormal result as below:

"Castlenet;""CastlenetSAS603"";""2N38024000001"";""

It seems that every "double quotation marks" appear twice time

But another function " excel get data"  indicates the right data as below

Castlenet;"CastlenetSAS603";"2N38024000001";" 

I try them on different OS (XP or Win7) and different labview version(8.5,8.6); but get the same result

read speadsheet file can't indicates the right data, does anyone can help on this?

[Dennis_Knutson · Accepted solution]

You would have to do a search and replace to eliminate the quote marks. I believe the quotes in a csv file are allowed in a proposed standard but the LabVIEW implementation does not fully comply with the proposal.

There is an idea exchange post on this that I can't find right now.