Match up to underscore

[rocket976 62]

Need a little regex help with look ahead (I think)

Trying to get all numbers up to an underscore "_" for ex

 

146973095502995_234698373397133

 

So hoping to get

 

146973095502995_

 

or better yet

 

146973095502995

 

AND Then would also need the regex to match all characters after the underscore "_"

 

_234698373397133

 

or better yet

 

234698373397133

 

best ive came up with is

 

^[a-zA-Z0-9_]+$ but that just gets the entire string

 

 

Thanks for reading

[Kreatus (Ubot Ninja) 422]

Here's one way to do it.

set(#numberVar, $replace($find regular expression("146973095502995_234698373397133", "[0-9]\{15,20\}_"), "_", ""), "Global")

[rocket976 62]

Thanks that works , I can also replace it out of the original var to get the second part , the after _ , much appreciated.