Skip to main content
Question

Extract Part number from a long text field

  • July 2, 2018
  • 0 replies
  • 38 views

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
This topic has been closed for replies.

  • Quickbase Alumni
  • July 2, 2018
Try this:

Right(Left([URL], "?"), "/")

  • Author
  • Quickbase Alumni
  • July 2, 2018
Thanks it did the Job