+ Reply to Thread
Results 1 to 4 of 4

Assistance with parsing text between characaters

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Assistance with parsing text between characaters

    I have a column A that each cell has 3 lines in it.

    Example:

    Cell A1:
    Plugin Output:
    Hostname : Dave-L-123456789
    Dave-L-123456789 (WMI)

    Cell A2:
    Plugin Output:
    Hostname : Dave-L-222222222
    Dave-L-222222222 (WMI)

    Cell A3:
    Plugin Output:
    Hostname : Dave-W-010101010
    Dave-W-010101010 (WMI)

    These are computer names. Lines 2 and 3 are basically the same thing.
    Is there a way to parse this out so it just gives me the computer name? like Dave-W-010101010
    There is not set amount of characters for the computer name which make it tough.

    The best i've gotten so far is:
    =RIGHT(A1,LEN(A1)-FIND(":",A1))
    but it just returns both computer names

    Thanks

  2. #2
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance with parsing text between characaters

    This returns with the computer name from both lines 1 and 2.
    =TRIM(
    MID(
    SUBSTITUTE(A1, " : ", REPT(" ", 99)),
    2 * 99 - 98,
    99))

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Assistance with parsing text between characaters

    Give this a short
    =RIGHT(A1,LEN(A1)-FIND(":",A1,FIND(":",A1)+1))
    Teach me Excel VBA

  4. #4
    Forum Contributor
    Join Date
    05-17-2012
    Location
    Silver Spring
    MS-Off Ver
    Excel 2016
    Posts
    212

    Re: Assistance with parsing text between characaters

    I was able to get it working a different way.

    =MID(A1,
    SEARCH("name",A1+6,
    SEARCH(CHAR(10),A1)-1)

+ 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. Replies: 3
    Last Post: 02-27-2015, 03:59 PM
  2. Looking for Assistance with Parsing HTML for Strings
    By Andrew Andromeda in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-03-2015, 11:16 PM
  3. Replies: 1
    Last Post: 09-25-2013, 12:18 PM
  4. [SOLVED] Parsing Text
    By wpwalsh in forum Excel General
    Replies: 4
    Last Post: 08-09-2012, 05:17 PM
  5. Time Window Parsing Assistance
    By kingsolo in forum Excel General
    Replies: 6
    Last Post: 01-25-2011, 01:46 AM
  6. text parsing
    By captedgar in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-22-2010, 09:21 PM
  7. Parsing out text
    By halfordryan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2007, 04:37 AM

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