Extract first word without comma

[#1]

Hello everyone,

I need your help to know how I can extract the first word from a field, without take the comma.

I already use this :

subfield( [Family Description],' ',1) as [Family]

But, depending on the case, it takes me a comma that I don't want..

Thank you for your help !

[tresesco · Accepted solution]

Try:

PurgeChar(subfield( [Family Description],' ',1), ',')  as [Family]

[#3]

Thanks lot tresesco, it works !

[tresesco]

Muller scored a hat-trick, couple of hours later, I could help MULLER !