Access 2016 help: Separating out number for text.

%3CLINGO-SUB%20id%3D%22lingo-sub-278192%22%20slang%3D%22en-US%22%3EAccess%202016%20help%3A%20Separating%20out%20number%20for%20text.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278192%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20field%20in%20a%20table%20titled%20Description%20that%20has%20a%20mix%20of%20words%20and%20numbers.%26nbsp%3B%20The%20numbers%20can%20be%20found%20anyplace%20and%20combination%20with%20the%20text.%26nbsp%3B%20Is%20there%20a%20function%20or%20query%20that%26nbsp%3BI%20can%20run%20to%20extract%20the%20numbers%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3C%2FP%3E%3CUL%3E%3CLI%3ESmith%20Pass%20321%20Regular%3C%2FLI%3E%3CLI%3E73%20Pass%20Smith%3C%2FLI%3E%3CLI%3EExpress%2089%20Pass%20Porter%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThank%20you%20for%20your%20time%20and%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I have a field in a table titled Description that has a mix of words and numbers.  The numbers can be found anyplace and combination with the text.  Is there a function or query that I can run to extract the numbers?

 

Example

  • Smith Pass 321 Regular
  • 73 Pass Smith
  • Express 89 Pass Porter

Thank you for your time and help!

0 Replies