Removing leading zero from a Column with number

Hi there

I want to remove the leading zeros from my column
Can anyone help?
@Yoichi it’s from the same file. Column with Cust Purchase Order should not have leading zeros,


Hi @Sisay_Dinku

Give a try to this.

Loop through data table using for each row and inside use this
CurrentRow("PO #')=CurrentRow(“PO #”).ToString().TrimStart("0"c).ToString()


Hope this helps.

Hi @Sisay_Dinku

This is a duplicated topic, please close one of them, don’t make unsolved topics. People will get confused



I have four datatables, do I have to do all of one by one. Also, I want the non-leading zero POs back to data table to upload to Queue item. How would I do that?

Hi @fernando_zuluaga

Whenever there is an open ticket and unresoved how do we close without choosing the solution? Thanks!


You can merge datatable using Merge Data Table activity and then loop through the final data table.

Hope this helps

Flag the post, select the last option and request to delete the post, or else mark your own post a s solution


@Suraj_B_Shetty what is the expression/ query used to merge for data tables?


You can use merge data table activity


Thanks a lot. Good to know that!

Hi @Suraj_B_Shetty. Thanks you. Yes, I am able to remove the leading zeros.

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