Formula Removing Leading Zeros

Hello,

I have a column that Alteryx is adding in leading zeros, this field, when opened in excel, does not have the zeros, I'm sure there's an explaination why Alteryx is adding zeros. However, my question is regarding the formula I am using to remove said zeros. It's not working and I don't know why, I have added brackets and parenthesis where appropriate.

Below are examples of the formula I am using and an example of the data.

Please help.

Best Practices

Accepted answers

Got your issue, this is because of the column name.

Trimleft([[REQ] Supplier (Common Supplier ID)],"0")

The column name contains the [].

Have tried the column name without [], then the formula works fine.

Many thanks

Shanker V

All comments

It is due to the datatype issue.

Trimleft will work on String types, but the column you are using in Integer type.

To overcome the issue, use the below formula

Tonumber(Trimleft(tostring([column name]),"0"))

Many thanks

Shanker V

I changed it to an integer and it still gives me the error.

Please use the below formula.

Tonumber(Trimleft(tostring([Field1]),"0"))

Many thanks

Shanker V

Got your issue, this is because of the column name.

Trimleft([[REQ] Supplier (Common Supplier ID)],"0")

The column name contains the [].

Have tried the column name without [], then the formula works fine.

Many thanks

Shanker V

@ShankerV Thank you!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703