Solved

Parse string function

Posted on 1998-10-12
3
160 Views
Last Modified: 2010-04-30
I have 2 strings. In these strings I have values seperated by ;

Locations = "blablubla;bobbabbib;jamjam;namnam;"
Visits = "200;300;50;80;"

I need a function that can give me the X value of both strings.
Example:
strValue1 = Gime(Locations,2)
strValue2 = Gime(Visits,2)
will return this:
strValue1 = bobbabbib
strValue2 = 300
0
Comment
Question by:jfl
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
clifABB earned 20 total points
Comment Utility
Public Function ParseString(sText as String, nSection as Integer)
  Dim sTemp   As String
  Dim nPtr    As Integer
  Dim nCnt1   As Integer

  For nCnt1 = 1 To nSection
    nPtr = Instr(nPtr + 1, sText, ";")
    If nPtr = 0 Then
      ParseString = ""
      Exit Function
    End If
  Next nCnt1
  sTemp = Mid$(sText, nPtr + 1)
  ParseString = Left$(sTemp, Len(sTemp) - Instr(sTemp, ";")
End Function
0
 
LVL 6

Expert Comment

by:clifABB
Comment Utility
Oops...
I tried to do this off the top of my head, but screwed up.

Here is the real working code (I tested it this time):

Public Function ParseString(sText As String, nSection As Integer)
  Dim sTemp   As String
  Dim nPtr    As Integer
  Dim nCnt1   As Integer

  For nCnt1 = 1 To nSection - 1
    nPtr = InStr(nPtr + 1, sText, ";")
    If nPtr = 0 Or nPtr >= Len(sText) Then
      ParseString = ""
      Exit Function
    End If
  Next nCnt1
  sTemp = Mid$(sText, nPtr + 1)
  nPtr = InStr(sTemp, ";") - 1
  ParseString = Left$(sTemp, nPtr)
End Function

0
 
LVL 4

Expert Comment

by:mcix
Comment Utility
Here's a little function that does the same sort of thing:

Function Token(LookIn As String, Delim As String, tkno As Integer) As String

    ' this function extracts token #tkno from a
    ' string of tokens (LookIn) separated by a delimiter (Delim).
    ' last character in (LookIn) *must* be a delimiter

    Dim ptr As Long, ptr0 As Long, tptr As Long
    ptr = 1
    ptr0 = 1
    tptr = 1
   
    Do
        ptr = InStr(ptr0, LookIn, Delim)

        ' if we can't find any more tokens
        ' check to see if this is the one we want
        If ptr = 0 Then
            If tptr = tkno Then
                Token = Mid(LookIn, ptr0)
            Else
                Token = Empty
                Exit Do
            End If
        Else
            ' do we have correct token?
            If tptr = tkno Then
           
                Token = Mid(LookIn, ptr0, ptr - ptr0)
                Exit Do
            End If
        End If
        tptr = tptr + 1
        ptr0 = ptr + 1
    Loop
End Function


0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now