Parse word? Name?

[Novice1]

I want to extract the first word (name) in a query. The field could be ...

John P
John
John Paul

I only want "John" to appear. If the space was always present it would be simple. This is what's driving me batty.

 

[jdraw]

Is this the same issue as you presented here? and here?

If so, and the requirements have changed, it seems more analysis of the requirements required.
There is no need to keep adding new threads for the same issue.

What is the format of the source material?
Please show some sample data.

 

[micks55]

If you always want the first word, then
=Left([yourField;InStr([yourField];" ")-1)
but you'll have issues if the first word has been entered as an initial only.
Sorry, just re-read your question and this does not check for a space character.

Try this.
=Left([yourField],abs(instr([yourField]," ")-1))