Avatar of SpaceCoastLife

asked on 

Seperating text and numbers in a string

I'm looking for help separating text from numbers in an Access string. Example: "BURLINGTON TOWERS1000 BURLINGTON AVE N 603"

I need everything left of 1000 in it's own field.

There are a few thousand records with every combination of text and numbers in this table with no space between than.
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon