01-23-2015 08:37 AM
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?
Solved! Go to Solution.
01-23-2015 06:02 PM
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
01-26-2015 03:28 AM
Thank you very much! As "clear" saved file it had no quotations marks!
01-26-2015 04:34 AM
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.:
dim targetFilePath : targetFilePath = "C:\temp\EXAMPLE.csv" Call DataFileSave("<filename>" & replace(targetFilePath, "&", "&") & "</filename><decimalpoint>.</decimalpoint><delimiter>,</delimiter>", "CSV")
Germany
dim targetFilePath : targetFilePath = "C:\temp\EXAMPLE.csv" Call DataFileSave("<filename>" & replace(targetFilePath, "&", "&") & "</filename><decimalpoint>,</decimalpoint><delimiter>;</delimiter>", "CSV")
01-28-2015 03:15 AM
Thank you! Yes, I have seen such possibilities here in forum. I don't understand, why it is not noted in DIAdem-Help.