Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Visual Basic
  4. split string by tabstop in VBA for Word

split string by tabstop in VBA for Word

Scheduled Pinned Locked Moved Visual Basic
databasehelpquestion
4 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Stephan Wright
    wrote on last edited by
    #1

    hy everyone! I do want to do the following: I want to split strings using the tabstop as a seperator, so I do need something like this stringarray()=Split(mystring,tabstop) but I have no idea which ascii caracter I have to use to do so. Because Word or Windows uses the a special character to display non printable characters. Could anyone help me please? Because I do need this to get the chapterindizes out of an index. Thanks! Stephan.

    D L 2 Replies Last reply
    0
    • S Stephan Wright

      hy everyone! I do want to do the following: I want to split strings using the tabstop as a seperator, so I do need something like this stringarray()=Split(mystring,tabstop) but I have no idea which ascii caracter I have to use to do so. Because Word or Windows uses the a special character to display non printable characters. Could anyone help me please? Because I do need this to get the chapterindizes out of an index. Thanks! Stephan.

      D Offline
      D Offline
      Dave Kreskowiak
      wrote on last edited by
      #2

      Tab is ASCII character 9. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

      1 Reply Last reply
      0
      • S Stephan Wright

        hy everyone! I do want to do the following: I want to split strings using the tabstop as a seperator, so I do need something like this stringarray()=Split(mystring,tabstop) but I have no idea which ascii caracter I have to use to do so. Because Word or Windows uses the a special character to display non printable characters. Could anyone help me please? Because I do need this to get the chapterindizes out of an index. Thanks! Stephan.

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #3

        there is also a vb constant for this: vbtab Also useful is vbcrlf Also, the helpfiles has tables of the ASCII characters as reference for console applications. Look up the CHR() or ASC() function in the index and there's a link to them.

        D 1 Reply Last reply
        0
        • L Lost User

          there is also a vb constant for this: vbtab Also useful is vbcrlf Also, the helpfiles has tables of the ASCII characters as reference for console applications. Look up the CHR() or ASC() function in the index and there's a link to them.

          D Offline
          D Offline
          Dave Kreskowiak
          wrote on last edited by
          #4

          Whoops! I forgot about that! Hardly ever use vbTab... RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups