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:

61421d29-83e9-43dd-bckl-5832145aec51

614212983

1 Like

Something like this will work:

{text="61421d29-83e9-43dd-bckl-5832145aec51"}

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

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

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

2 Likes

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