Parsing text with tags in Excel using VBA

Hot Topic

format numbers in html
Error VB6 when I run application in w2k3 Domain Controller
assigning event handler subs to a dynamically created control?possible? how?
Access Project and Views
passing a xml document from Excel to Oracle *urgent help please*
Opening a Word Document from an Excel VBA Module
Problems with DAO and SQL Server
possible to access word vba via c/c++?
internet explorer 6 prefetching webpages?
Future of VBA (and VBScript)?

Microsoft ISV

Crying like a baby
How to build this??
Calendar control issue in excel
MS Office document and image writer print driver
XML view in IE
Read data from excel through VB.NET
VBA in Office 12
BSM Scorecard Report Views
WORKING ON WORKBOOK WITHOUT OPENING IT
Business Scorecard Manager Test Server

Parsing text with tags in Excel using VBA

Hello,

I need to parse a text containing tags.

The problem is that all of the VBA parsing functions I found divide the text using one char delimiters.

Any ideas

Thanks,

Raphael Cohen

Bioinformatics Support Unit

Ben-Gurion University

Answer this question

Parsing text with tags in Excel using VBA

  • Mike Reese

    Have you tried the VBA Split function It came in with Excel 2000 but can be simulated in earlier versions.

    a$="h<t>a<t>p<t>p<t>y"
    b=Split(a$,"<t>")

    produces:
    b(0) = "h"
    b(1) = "a"
    b(2) = "p"
    b(3) = "p"
    b(4) = "y"

    Any good


  • Devi

    I think thats what I was looking for.

    Thanks.

    Raphael.
  • Parsing text with tags in Excel using VBA
Answer this question