SamKrausz
7 years agoQrew Cadet
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
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