Extract first 9 numbers only from string

Hi! This is a similar challenge to my phone number issue, but I still don't have it down yet. Unfortunately, I don't have time currently to work on this problem.

I need to get the first 9 numbers in a string like this one:



1 Like

Something like this will work:


Get a list of all the numbers:
{matches=extractregexall(text, "\d")}

Get the first 9 numbers, and join them into a string:

{=join(slice(matches, 1, 9),"")}


That works perfectly @scott . Thank you very much! :fire: