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

[ph0703]

Hi,

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!

[izaychik63]

You can fix it in File Reader node.

[ph0703]

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

[mlauber71]

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