Getting Specified Data Out Of A Long Text String

What if you only wanted to extract portions of data out of a long text string? For example, how can you extract the string 0001 from the entry 111111111100010000000000?


This function will work with any text string and parse from a starting position through the number of characters or spaces required.

Tip initially comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 21 August 2001.