Extract Part number from a long text field

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,954 Points 20k badge 2x thumb
Try this:

Right(Left([URL], "?"), "/")
Photo of Sam Krausz

Sam Krausz

  • 470 Points 250 badge 2x thumb
Thanks it did the Job