Capitalised Text Extraction

  • Thread starter Thread starter Bobby Internet
  • Start date Start date
B

Bobby Internet

I have a single field in a table displaying multiple occurrences of 2 Letter
UK Postcode combinations which I would like to use to drive a query, here is
an example of the data

NN, MK
BS, OX
NP (15) SA (15)
BS,BA,TA,GL

I would like to only extract the data in capitals and then list each one
once in query, so the results from this data would be

NN
MK
BS
OX
NP
SA
BA
TA
GL

TIA

Bob
 
This is something that will not be solved with a query. You will need to
write some VBA code to perform parsing on the text, then write the values to
a table.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top