How to remove leading zeros from data table column

Help Studio
, , , ,
1

hello all,

I would like to remove leading zeros from a data table column. please check my data.
leadingzeros
from depost column i want to remove leading zeros. Would you please suggest me how would i achieve this.

Thanks in advance.

2

Hi @roysupriya21

first read the excel file using read range and store in dt1 variable

  1. Now use invoke code activity with dt1 variable as In/Out argument, the code to used is

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Depost”)= CInt(row(“Depost”).ToString))

write the datatable dt1 to excel using write range

Hope it helps
.
Regards,

Nived N
Happy Automation

2 Likes
3

@roysupriya21,

Follow weblink, check if zeros are running away.
if works, then you have to automate that part before you actually read excel

4

I did not get any web link . Would please re send .

5

@roysupriya21,

I’m sorry, here you go,

6

it is working . Thank you.

1 Like
7

hello,

I would like to take one more suggestion from you . my actual requirement is I will remove leading zeros only when the length of the string less than or equal 6 in depost column. for more reference I have also added the data.
leadingzeros_1

I will be very humbled if you give me some suggestion.

thanks in advance

8

Hi @roysupriya21
for this we had to do some modifications in same code as i told above

Modified code

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“Depost”)= If(row(“Depost”).ToString.Length<=6,CInt(row(“Depost”).ToString),row(“Depost”)))

Try this and let me know if it works

Regards,
Nived N
Happy Automation

1 Like
9

I did try your code. but it is showing error. please check the screenshot.

error_invokecode
error_invokecode1366Ă—768 88.1 KB

10

Hi @roysupriya21
sorry, there was mistake, i had corrected the code, please look that

Regards,
Nived N
Happy Automation

11

Thanks a lot . it is working perfectly.

1 Like
13

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