1

Topic: To break a line into words

Friends, salute!
Prompt - as from a line N101HV65 the valve the first to single out N101HV65
Function Left does not approach, as an amount of characters at  a miscellaneous.
In advance thanks!

2

Re: To break a line into words

MyString = "N101HV65 the valve the first"
FirstWord = Split (MyString) (0)

3

Re: To break a line into words

STING_WRX wrote:

Prompt - as from a line N101HV65 the valve the first to single out N101HV65

I.e. to the first gap?

s2 = Split (s1, "") (0)

4

Re: To break a line into words

STING_WRX,

5

Re: To break a line into words

Anatoly (Kiev);
Prompt, please, and in request also : _: Split ([Tekst_1], "") (0)?

6

Re: To break a line into words

And here in request it is necessary to be turned out so:

SELECT..., LEFT (field, INSTR (field AND "", "")-1) AS FirstWord...

7

Re: To break a line into words

Though instead of subtraction of unit it is better to envelop it in Trim ().

8

Re: To break a line into words

STING_WRX;
And that hinders to apply in request function: "SELECT..., my (field) FROM."

9

Re: To break a line into words

sdku wrote:

that hinders to apply in request function

If all happens within the limits of one file of a DB and MS Jet - yes, will be equal. Otherwise ...

10

Re: To break a line into words

Akina;
Thanks!

11

Re: To break a line into words

Akina;
It completely agree, but in  operation with several bases did not make a reservation