"Save as csv" sets quotation marks around the whole line

[Sasha_62]

Our client reports:

Data portal->Right click->Save as->Select "Data type": "Textfile - Auto detect (*.csv)"->Save.

Result of saving:

"TIME    V    V_ABS"
"63.0235776    0.105263157894737    28.6153372301571"
"63.0235936    0.105264137235745    28.6156034598028"

Therefore values of channels with same index (and a header) are compound to one cell due to quotation marks around.

By me it doesn't happen, but by a client.

Client has normal German Windows 7 region/language configuration.

Any idea, how a client can save as csv without quotation marks around the line?

[Pesmith8 · Accepted solution]

Sasha

Checked the file format when saving data portal to Test File (CSV) .

When I checked the file in Ultraedit (so can see the hex values)  The file does not have any quotes around the values.

But if I opend the file in Excel and then saved it. Excel did put the quotes like what was shown in your post.

Looks like the customer is opening the file in Excel.

Paul

[Sasha_62]

Thank you very much! As "clear" saved file it had no quotations marks!

[AndreasK]

Using a script it is possible to write CSV files Excel natively opens like given in this forum entry.

But be aware that you need different kind of files depening on your country.
In the Excel world CSV means "Character Separated Values".

e.g.:

• US
  

  dim targetFilePath : targetFilePath = "C:\temp\EXAMPLE.csv"
  Call DataFileSave("<filename>" & replace(targetFilePath, "&", "&amp;") & "</filename><decimalpoint>.</decimalpoint><delimiter>,</delimiter>", "CSV")

• Germany

  dim targetFilePath : targetFilePath = "C:\temp\EXAMPLE.csv"
  Call DataFileSave("<filename>" & replace(targetFilePath, "&", "&amp;") & "</filename><decimalpoint>,</decimalpoint><delimiter>;</delimiter>", "CSV")

...

[Sasha_62]

Thank you! Yes, I have seen such possibilities here in forum. I don't understand, why it is not noted in DIAdem-Help.