+ Reply to Thread
Results 1 to 4 of 4

Retrieve values from string.

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    NL
    MS-Off Ver
    Excel 2016
    Posts
    74

    Retrieve values from string.

    I'm retrieveing a string from a emailbody, this string contains text, tabs and numeric values.

    With that:
    Please Login or Register  to view this content.
    retuns: 'ID_123456_YYYYMMDD.180624133119335.csv 120 0 0 5 0 0"
    but in my Excel sheet it looks like this: 'ID_123456_YYYYMMDD.180624133119335.csv12005000"

    Therefore i replace the tabs with '|', with that:
    Please Login or Register  to view this content.
    returns: ID_123456_YYYYMMDD.180624133119335.csv|120|0|0|5|0|0|

    Now I would like to 'use' the numeric value 120 and 5(these are always in the 2nd and 5th place of the string

    What is the best way to get these values out of my string?

    Thanks in Advance

    ABBOV

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Retrieve values from string.

    Please Login or Register  to view this content.
    Should return the 2nd position (120)
    Please Login or Register  to view this content.
    will return the 5th (5)

    or instead of replace... use the Cells(p,5).Value if you prefer.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    07-26-2010
    Location
    NL
    MS-Off Ver
    Excel 2016
    Posts
    74

    Re: Retrieve values from string.

    Thanks, that did the trick!

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Retrieve values from string.

    Excellent!
    Thanks for the feedback, and marking the thread as solved.

+ 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] Retrieve amount from string in VBA
    By ArnolddG in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2018, 12:04 PM
  2. Different way to retrieve numbers a text string.
    By jonagpa in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-21-2016, 06:37 PM
  3. [SOLVED] Search for a string and retrieve string from an adjacent cell.
    By djt80 in forum Excel General
    Replies: 5
    Last Post: 01-27-2015, 03:57 PM
  4. How to retrieve second to last letter of a string
    By ltg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2008, 11:33 AM
  5. Retrieve Weekday from String
    By rasak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2008, 04:00 PM
  6. [SOLVED] VB.Net - retrieve actual formula string
    By Grant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2006, 01:20 PM
  7. [SOLVED] How do I retrieve the text string from the right of a cell
    By JWG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2006, 10:35 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