split coloumn value

[mhamurcuoglu]

Hi,

Sorry for my English

I have below table and I want to split only numbers to another coloumn with scprit.

How can I make it

Thanks

NameID
Ali(1239)
Tom(4343)
John(95845)

[ali_hijazi · Accepted solution]

load num(Textbetween(NameID,'(',')'))

[sunny_talwar]

or if you will always not have numbers outside of parenthesis, then you can also try this

KeepChar(NameID, '0123456789')

[avinashelite]

Try like this

num(keepChar(NameID,'0123456789')) as new_column

[mhamurcuoglu]

Thank you so much