Extracting the 1st word from a field

[Cort]

Please help.

CR 9.0.

I have a field where I want to extract the first word in the field. I can imagine having to search for the first space in the field and then using everything to the left of that space but can't figure out how to write the formula.

Any ideas?

Thanks.

Ex: "David Boston"
I want to extract just David.

 

[crystalreporting]

Try this;

Left({table.field},(InStr ({table.field}," &quot -1))

Peter Shirley

http://www.linkcorp.com

 

[Cort]

Thanks. It's also in the FAQ. Dangit shoulda looked there first.