Trimming more than one Words

[henni2003]

I have a Name field in my DB which can have more than one name seperated by spaces. I want to trim this name-field to just one word while outputting.

Example:
"Michael Theodor John"

Is outputted as simply
"Michael"

I'm working with trimming and find but not quite getting it right. Anyone suggestions?

Thank you very much,
Henrik

[azadisaryev · Accepted solution]

you can treat the name as a space-delimited list and use the ListGetAt function to get the first element of the list:

<cfoutput>#listgetat([youqueryname].name, 1, " ")#</cfoutput>

[henni2003]

Thanks, works like a charm!

[Newsgroup_User]

Just to spread the knowledge of CF functions you could have also used
the listFirst function which returns the first element of a list.

<cfoutput>#listFirst([youqueryname].name," ")#</cfoutput>