LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Denis Drouais

Hello,

I need to export my data in csv (UTF8 format). I am using the Output Excel node for now (the file name being XXXX.csv) but it just creates a Excel file with a .csv extension. I have tried open the created excel file and save it as csv file but the encryption is AINSI and not UTF8.

Is there a way to create a csv in UTF8 encryption directly from Lavastorm ?

Thank you very much in advance

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Use Output Delimited, with these settings:

FieldNames=Names
FieldDelimter=,
RecordDelimiter=\n

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Denis Drouais

Thank you.

Do you have any idea why a string element in lavastorm becomes a number in the csv (ex : 54206547900686 becomes 5,42065E+13) and a double element is recognized as text ("49.246444" as text)

Plus, I'd like the date format i'm using in lavastorm (yyyy-mm-dd) to remain as it is in the csv whereas it becomes dd/mm/yyyy in the csv

PS : I'm using a French version of Excel where decimals are marked with a coma "," and not a dot "."

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

The answer to all of your questions is "Excel". Open the file with a text editor, and you will see the data is "clean" in the file.. it is Excel that is making the format changes. (except for the period-versus-comma issue)

There are various ways around the issues, perhaps it would help us offer the best solution if you could tell us more about what you're trying to accomplish. For Example: If you're just going to open the file in Excel anyway, why not write out an XLS in the first place?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Denis Drouais

The end goal is to upload a file in a web plaform developped for data visualization. The developpers are awating a specific csv file that I first made via Excel but want to produce through Lavastorm as the data agregation is getting more complicated. The main issue right know is the period-versus-comma issue, I guess. Is there a way to get a "," instead of a "." as decimal seperator through Lavastorm?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

You can convert the numbers to strings and then use the replace operator to fix the periods.

For example:

emit format("%0.2F",myField).replace(".",",") as myFormattedField