This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can use the Formula Tool and the TrimLeft() function to remove leading zeros.
TrimLeft(String,"y") - Removes y from the beginning of String. Defaults to trimming whitespace.
TrimLeft([Field1],"0") removes all 0 characters from the beginning of the string. If you do not want to replace 0 with "", filter all records that == '0', use TRIMLEFT() on all other strings, then union the results.
Note: Using Trim() will remove the string from the beginning and end of the string.
You could also use the Regex tool to find and replace leading zeros.