Forum Discussion

SamKrausz's avatar
SamKrausz
Qrew Cadet
6 years ago

Extract Part number from a long text field

Here is my text data 

https://www.walmart.com/ip/Brother-P-touch-CUBE-Smartphone-Label-Maker-with-Bluetooth-Wireless-Technology-Blue/957734631?wpa_bd=1529960955145&wpa_ref_id=b_affcfdad-910c-4984-a9df-d675f679a551&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=3&wpa_plmt=__plmt__&wpa_aduid=__aduid__



I am looking to get out the 957734631

is there any way to do it? When I try to use the part function I got this:

957734631?wpa_bd=1529960955145&wpa_ref_id=b_affcfdad-910c-4984-a9df-d675f679a551&wpa_aux_info=__aux_info__&wpa_tag=__tag__&wpa_pos=3&wpa_plmt=__plmt__&wpa_aduid=__aduid__

https://www.screencast.com/t/yCcIx8efHN0

https://www.screencast.com/t/tpHYTngIyXg