More than 1 year has passed since last update.

最後の「.」の後の出力文字を検索する式

Salesforce

Last updated at 2022-03-28Posted at 2021-10-19

Formula to locate to Output Characters after the Last "."

MID(
    MID(
    (MID(Username__c, FIND('@', Username__c)+1, 100)),
    (Find (".",(MID(Username__c, FIND('@', Username__c)+1, 100))))+1,
    100),
    FIND(".",
    MID(
    (MID(Username__c, FIND('@', Username__c)+1, 100)),
    (Find (".",(MID(Username__c, FIND('@', Username__c)+1, 100))))+1,
    100))+1,
    100
)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up