How to isolate text before numbers in string

[Femke_DPG]

Hi all

I want to isolate the name in the string before the 'point': FIRSTNAME.LASTNAME1.5431581498658286E12

I am using this: 

Left(accountmanager, If(FindOneOf(accountmanager, '0123456789') > 0, FindOneOf(accountmanager, '0123456789'), Len(accountmanager)))

But then I get:

FIRSTNAME.LASTNAME1 (I want to eliminate the '1') and just recover the name. 

Thx!

Femke

[Mark_Little · Accepted solution]

Hi Review the Subfield function.

Try Somthing like

SUBFIELD(accountmanager,'.',1) as FirstName

SUBFIELD(accountmanager,'.',2) as SurnameName

IF you want to remove a number of the end

LEFT(SUBFIELD(accountmanager,'.',2),LEN(SUBFIELD(accountmanager,'.',2))-1) as SurnameName

[sk002]

Can you add a sample dataset ?