Skip to main content
How to make 'Create CSV' Action Flow module create column as float rather than string? Numbers always get wrapped in double quotes which causes the back-end to interpret them as strings rather than floats. How to get these numbers recorded w/o the " "?

Hello Michael,

 

I have not experienced the exact same issue yet.

 

However, what always worked for us it to "play" with the item types when defining the "Data Structure".

There is an item type "number", which might do the trick?

 

How to access the item type option (within the "Create CSV (Advanced)"-Module ):

  1. Data structure -> next to its add-button you can find the drop down with "Edit Item" -> click on it
  2. Within edit item you will find items within your data structure
  3. Find the item linked to your float and change the item type to number

 

PS: In general, always try to opt for the the "Create CSV (Advanced)"-Module

 

I hope this solves your problem!

 

Best

Denis

 


Hello Michael,

 

I have not experienced the exact same issue yet.

 

However, what always worked for us it to "play" with the item types when defining the "Data Structure".

There is an item type "number", which might do the trick?

 

How to access the item type option (within the "Create CSV (Advanced)"-Module ):

  1. Data structure -> next to its add-button you can find the drop down with "Edit Item" -> click on it
  2. Within edit item you will find items within your data structure
  3. Find the item linked to your float and change the item type to number

 

PS: In general, always try to opt for the the "Create CSV (Advanced)"-Module

 

I hope this solves your problem!

 

Best

Denis

 

I tried using 'number' as item type, as well as parsing to a number to no avail. It always seems to export with double quotes around the number. For now I just decided to convert my numbers to strings and do string compares when needed.


Reply