Remove Leading Zeroes in days and months

BautistaC888

Hello:

I need to remove the leading zeroes from my dates.
For example (the dates are dd/mm/yyyy in string format):

And i need:
2/1/2020 First line.

Thank you.

atcodedog05

Hi @BautistaC888 

Here is how you can do it.

Formula:

REGEX_Replace([Field1], "0?(\d+)/0?(\d+)/(\d+)", "$1/$2/$3")

Workflow:

Hope this helps : )

remove zero.yxmd