Extract first part of text string

  • Thread starter Thread starter Kimbur
  • Start date Start date
K

Kimbur

How can I extract the first part of a text string when it is varying lengths?
I need to pull the first few characters of the string (between 1 and 5
characters) that are always before the first space (" "). I have strings
which look like this, "1 APOL 70-145-01" and "2-1/2 APOL 70-109-01A" so my
desired result would be "1" and "2-1/2" respectively.
 
hi,
How can I extract the first part of a text string when it is varying lengths?
I need to pull the first few characters of the string (between 1 and 5
characters) that are always before the first space (" "). I have strings
which look like this, "1 APOL 70-145-01" and "2-1/2 APOL 70-109-01A" so my
desired result would be "1" and "2-1/2" respectively.
Click to expand...
Use

Left$(yourString, InStr$(yourString, " ") - 1)

in either code, a query or as a control source.


mfG
--> stefan <--
 
Back
Top