CSV: transform the string into float Anatella and keep the value

jerome

New member
let’s suppose that we have a CSV file that contains values as 1,589,254.3. Is there any configuration in the CSV action that is able to read correctly this figure? Currently, using the standard configurations, if we transform the string into float Anatella keep the cell empty instead of recognizing the number
 

Support

Administrator
Staff member
use a "replaceStrings" box to remove the comma's, like this screenshot (and see also the example in attachment):

2022-05-23_113204.png
 

Attachments

  • replace_Commas_examples.anatella
    1.7 KB · Views: 219
Top