Forum Discussion

Loic_Pedro_Hans's avatar
Loic_Pedro_Hans
Regular Visitor
2 years ago
Solved

problem with text functions

Hi,   I try to buid a simple formula to extract the first name   My formula is :    Prenom = VAR Pos_Virgule = IFERROR (FIND(",",Customer[Name]), BLANK() ) VAR Taille = LEN( 'Customer...
Need Help
Loic_Pedro_Hans's avatar
Loic_Pedro_Hans
Regular Visitor
2 years ago

Thanks Sakiko !!

I see my error

 

Prenom =
VAR Pos_virgule = IFERROR (FIND(",",Customer[Name]), BLANK() )
VAR Taille = LEN( 'Customer'[Name])
VAR Mon_Prenom =
    IF (
        NOT ISBLANK(Pos_Virgule),    
        LEFT( 'Customer'[Name], Taille - Pos_virgule),
        'Customer'[Name]
    )
Return Mon_Prenom