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

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?

Designer Cloud

Regex

Parse

Accepted answers

Hi @arsalanzaki

Please use the below Regex expression.

(\d+)$

Many thanks

Shanker V

All comments

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

Hi @arsalanzaki

Please use the below Regex expression.

(\d+)$

Many thanks

Shanker V

Hi @arsalanzaki

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

Screenshot 2024-04-29 090325.png

Many thanks

Shanker V

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703