Using RegEx trying to extract numbers after Telstra Site ID and Parse into a new field

[arsalanzaki]

Hi guys,

Using RegEx, I am trying to extract numbers after Telstra Site ID, from the text "Telstra Site ID 12049", and parse these numbers into a new column. Can somebody please write me the expression and guide on the steps to achieve this?

[arsalanzaki]

So the outcome is to get the numbers 12049 parsed into a new column.

[ShankerV · Accepted solution]

Hi @arsalanzaki 

Please use the below Regex expression.

(\d+)$

Many thanks

Shanker V

[ShankerV]

Hi @arsalanzaki 

Please find the below use case.  Hope this helps!!!

Many thanks

Shanker V