Find and replace with blank

[Carlyn]

Hi

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

[perin · Accepted solution]

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.

[Carlyn]

Thank you that worked a treat!

[Ankur_BDO]

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