How can I fix number stored as text issue with the CSV reader node?


I have a CSV file and some of the columns contain numbers this way: =“7926538”. In the cell I see only the number but when I start to edit there’s = sign before the value. How can I set the CSV reader node to remove = sign? Now I put " in the Quote Char field and after executing it look like =7926538.

Thanks for your help!

You can fix it in File Reader node.

Sorry but I still can’t see. Should I change something in the Advanced / Quote support option?

Import as string, remove unwanted part, convert to number?


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.