+ Reply to Thread
Results 1 to 7 of 7

Pulling out a value from a string

  1. #1
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    82

    Pulling out a value from a string

    I have a column that contains values like the below. They are consistently formatted in this way.

    example.org/portal/TO_Pulse?key=01fb3df8-77f4-4eef-b39c-8e935ec45189&TO_Pulse=Not+Likely&utm_campaign=example&utm_source=example&utm_medium=example

    In a separate cell I need to pull out the value that comes after &TO_Pulse and before the following ampersand.

    So I'd want to return the value "Not Likely".

    What formula would I need to do that please?
    Last edited by kimi01; 04-20-2021 at 11:46 AM. Reason: Clarity

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: Pulling out a value from a string

    Your file cannot be opened. Suggest you read the yellow banner at the top of this page and upload a file for analysis.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Pulling out a value from a string

    Alan
    I think the "file" reference is the actual string to be deconstructed i.e.

    https://example.org/portal/TO_Pulse?...5189&TO_Pulse=Not+Likely&utm_campaign=example&utm_source=example&utm

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Pulling out a value from a string

    Try

    =MID(A1,SEARCH("TO_Pulse=",A1,1)+9,(SEARCH("&utm",A1,1)-SEARCH("TO_Pulse=",A1,1)-9))

    or

    =MID(SUBSTITUTE(A1,MID($A1,1,SEARCH("TO_Pulse=",$A1,1)+8),""),1,10)
    Last edited by JohnTopley; 04-20-2021 at 11:48 AM.

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: Pulling out a value from a string

    John,

    I guess I missed the mark on that one. Better polish my crystal ball so I can better read the minds of OPs.

    Alan

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Pulling out a value from a string

    I made the same mistake!!!

  7. #7
    Registered User
    Join Date
    06-07-2016
    Location
    Richmond, VA
    MS-Off Ver
    365 Apps for business
    Posts
    82

    Re: Pulling out a value from a string

    Thank you, that worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pulling characters from a string
    By mosesthetank in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-20-2018, 06:15 AM
  2. [SOLVED] Pulling string from a cell
    By Beh162 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-29-2017, 09:56 PM
  3. [SOLVED] Pulling a value from a string
    By Ataraxicatom in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2014, 09:16 AM
  4. [SOLVED] Pulling a string of text
    By Montoro22 in forum Excel General
    Replies: 5
    Last Post: 06-11-2013, 11:36 AM
  5. [SOLVED] Pulling sections of a string
    By weeble33 in forum Excel General
    Replies: 5
    Last Post: 08-07-2012, 11:47 AM
  6. Pulling only the number out of a string
    By bconner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2008, 03:32 PM
  7. [SOLVED] Pulling apart a string
    By Kevin O'Neill in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-06-2006, 01:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1