CSV inputs andautomatic rounding

[BillyL14]

Hi there

I am inputting 2 csv files into my workflow. I am using CSV because I learnt that if your input are called Book 1 and Book 2, and if you specify Book ?, then the two sheets will come in together.  I know that CSV automatically treats all data as v_string type. I have a column full of numerical data which I used select tool to change to double. The problem that I am having is that there are numbers in with commas, like 1,250 (for clarification, = 1250), it is rounding this to 1 after changing to double. Is there any way to avoid this rounding?

Thanks

[JosephSerpis · Accepted solution]

Hi @BillyL14 you would need to remove the comma before you convert the field to a double. I mocked up some approaches.

[BillyL14]

Hi @JosephSerpis that worked great! thanks