Extract first part of text string

[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.

 

[Stefan Hoffmann]

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.

Use

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

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


mfG
--> stefan <--