Find and replace with blank

I am trying to remove leading 000000's on some data.

I had thought that I could use find and replace, but the replace column requires something to be entered for it to reflect.

I have tried " " to insert a space with the idea that I would then remove the leading spaces, but that doesn't appear to work.

Can anyone advise a better way to remove these? This is not for every row, as not all rows have these 000000's in the reference.

See attached for context

Thanks
Carlyn

000000's.PNG

Help

Accepted answers

perin

Hello Carlyn,

I recommend you check the type of the data, a formula should solve your problem (I also added a tostring formula). I am attaching an example of a workflow to perform this replacement.

Have a nice week!

Best,

Gustavo.

RemovingZeros.yxmd

All comments

perin

Hello Carlyn,

I recommend you check the type of the data, a formula should solve your problem (I also added a tostring formula). I am attaching an example of a workflow to perform this replacement.

Have a nice week!

Best,

Gustavo.

RemovingZeros.yxmd

Carlyn

Thank you that worked a treat!

Ankur_BDO

Use a formula tool and apply the expression ReplaceChar([Target column], "Target column","Replacement char")

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335