Do we have an expression to extract the first name from the Contact1.Contact field?

Version 1

    Details

    Do we have an expression to extract the first name from the Contact1.Contact field?


    Resolution

    SUBSTR(contact1->contact,1,(RAT(" ",TRIM(contact1->contact))))
    This  expression extracts the firstname from the Contact field where you have  more than one first name. For example, you may have Jon Samuel Smith.  The expression will return Jon Samuel.

    SUBSTR(contact1->contact,1,AT(" ",contact1->contact))
    This  expression extracts the firstname from the Contact field where you have  one first name. For example, you may have Jon Samuel Smith. The expression  will return Jon.

    You can also use the GoldMine macro function &Firstname
    This will also return Jon from the value Jon Samuel Smith

    NOTE: If you wish to use these in the lookup.ini the expressions need to be prefixed with &
    For example &SUBSTR(contact1->contact,1,(RAT(" ",TRIM(contact1->contact))))