Discussions

Expand all | Collapse all

Extract Part number from a long text field

  • 1.  Extract Part number from a long text field

    Posted 07-01-2018 20:30
    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


  • 2.  RE: Extract Part number from a long text field

    Top
    Contributor
    Posted 07-01-2018 20:35
    Try this:

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


  • 3.  RE: Extract Part number from a long text field

    Posted 07-01-2018 20:43
    Thanks it did the Job