Match and Remove

[IreneTrieu]

Can someone please help me with the below

I am trying to match and remove data.  The data is not exact as the zeros were dropped in one file - see attached.  I need to find the data under "Asset ID" column from "Asset ID2" column and then drop the data on the output

Thank you in advance

Irene

[Sebastiaandb]

Hi @IreneTrieu ,

Not 100% sure what you want but if you want to have zero's back in the Asset ID column, just drop this in a formula tool on column 'ASSET ID":

PadLeft([ASSET ID], 12, 0)

It ensures all values consist out of 12 characters and are filled on the left side by zero's?

Greetings,

Seb

[IreneTrieu]

i tried the above and its not working:  error msg  "Parse Error at char(1): PADLEFT: 3rd argument must be a string (Expression #1)".  What am I doing wrong? 

Thanks

Irene

[grazitti_sapna · Accepted solution]

@IreneTrieu , Please use the below formula:

padLeft([Asset ID],12,"0"). The 3 argument must be in double quotes.

[Sebastiaandb · Accepted solution]

Sorry for not writing the full expression right @IreneTrieu (i just wrote it here without looking in Designer...)! thanks @grazitti_sapna

[IreneTrieu · Accepted solution]

Thank you so much for all your help