remove leading 0 after whitespace

[Muyi]

How to remove leading 0 after any whitespace in a string. For example: 

"415 09th Street" -> "415 9th Street"

[benakesh · Accepted solution]

Hi @Muyi ,

Try  replace([Field1],' 0',' ')    :  replace  'space and 0' with   space  . 

[Muyi]

Thank you! It worked!