Regex help

[Ray_Whyte]

Looking to use the Regex tool to extract the first 10 characters from a field. In some records the first 10 are all numeric, and others there are 9 numeric and a letter. The formula I am using is  \d{10,} and Tokenize is selected. On records where the first 10 characters are numeric; it works just fine. If the last character is a letter it returns a blank value..  Any of you clever folk offer up where I am going wrong?

[JosephSerpis]

Hi @Ray_Whyte \d{10} means find 10 digits so hence the issue. If you look at the regex tool you will find some helpful info. Also can you not use a left function as it sounds like your data is alphanumeric so would likely be a string field in Alteryx so using the left function is another option.