Removing leading zero from a Column with number

Help Studio
, ,
1

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,

Thanks!

2

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()

image

Hope this helps.

3

Hi @Sisay_Dinku

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

Regards!

4

@Suraj_B_Shetty

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?
Thanks!

5

Hi @fernando_zuluaga

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

6

@Sisay_Dinku

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

Hope this helps

7

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

Regards

8

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

9

@Sisay_Dinku

You can use merge data table activity
https://docs.uipath.com/lang-ru/activities/docs/merge-data-table

10

@fernando_zuluaga

Thanks a lot. Good to know that!

11

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

12

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