How to extract number from text cell

[SahadhKuruniyan]

I have to extract code from a cell. The text is not even so can't use text to filter. Is there any way we can extract the number

[apathetichell]

regex_replace([field[,"^(.*)_(\d+-\d+)_(.*)$","$2") is what I would start with...

[FinnCharlton]

@SahadhKuruniyan You want the text inbetween the underscores? Add a Regex tool, set it to parse mode and use the regular expression:

.+?_(\d+-\d)_.+

Hope this helps! 

[SahadhKuruniyan]

Thanks alot. However I bit confused here, Can you tell me what would be formula if I have to extract code between ()..eg (12423-4) and between(space....eg (2323-5