First word of a String

[Rachel30]

Hi,

I have a field called status. in this field I could have string link:-

New
Amendments Only

I only want the first word to show of the string ie:-

New
Amendments

Any idea's how to write an expression for this. Thanks Rachel

 

[SkipVought]

Hi,

Left([Field], InStr([Field], " ")-1)

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[grande]

Put the string into a variable (strWord in this example).
Then, use

If InStr(strWord, " ") > 0 Then
   strWord = Left(strWord, InStr(strWord, " "))
End If

If you're doing this in a query, the code would be

IIf(InStr([FieldName], " ") > 0, Left([FieldName], InStr([FieldName], " ")), [FieldName])

-------------------------
Just call me Captain Awesome.

 

[Rachel30]

Thanks guys. Rachel