Results 1 to 6 of 6

Thread: string manipulation

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Feb 2014
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by p45cal View Post
    Check out the Split and Join. I haven't looked in detail at what you want to do with the portions of the string, but this snippet will give you an idea of how you might go about it:
    Code:
    Sub blah()
    zzz = "(((p v q) > (r v (p v q))) > ((p & s) v (r v s))) > (p & r)"
    yyy = Split(zzz, ">")
    For i = LBound(yyy) To UBound(yyy)
      yyy(i) = aFunctionToProcessTheSubString(yyy(i))
    Next i
    result = Join(yyy, " glug ")
    MsgBox result
    End Sub
    It says there is a function not defined at this line of code:

    aFunctionToProcessTheSubString(yyy(i))

  2. #2

Similar Threads

  1. Reverse a string by using array method
    By hanishgautam in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 07-09-2013, 09:07 AM
  2. Extract Certain Characters From A Text String
    By bobkap in forum Excel Help
    Replies: 5
    Last Post: 05-24-2013, 06:25 AM
  3. Concatenate array string
    By tushar.tarafdar in forum Excel Help
    Replies: 2
    Last Post: 09-20-2012, 12:00 PM
  4. Find Color in the string using formula.
    By LalitPandey87 in forum Excel Help
    Replies: 4
    Last Post: 07-10-2012, 09:16 PM
  5. Find the First or Last So Many Words in a Text String
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 6
    Last Post: 06-21-2012, 09:42 PM

Posting Permissions

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