Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Try:
PurgeChar(subfield( [Family Description],' ',1), ',') as [Family]
Try:
PurgeChar(subfield( [Family Description],' ',1), ',') as [Family]
Thanks lot tresesco, it works !
Muller scored a hat-trick, couple of hours later, I could help MULLER !