Remove leading zero in CSV

[RichardAlt]

Hi All,

I'm having a problem with CSV when running on Alteryx.

This is my CSV file.

But when I run this on Alteryx,

This is the current output.

All of the columns have now led with zero's.

Any ideas why? Thanks!

[atcodedog05 · Accepted solution]

Hi @RichardAlt 

Use 

TrimLeft([Field],"0")

[atcodedog05]

Happy to help 🙂 @RichardAlt 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[RichardAlt]

Thanks for the quick response, I'd really appreciate it. It worked. Thaaaaaanks 🙂