Apex Code Development You need to sign in to do that
Don't have an account?
María Lobo To get a substring from the TextBody
Hello,
I need to get an information from an Inbound email and set it in a field.
The information always will look as: DUNS: 123456789
I want to do it with a Process Builder, with a immediate action "Update Record". I am trying to fill up the field with the 9 numbers, but I don´t know how to do get the strings.
I did a Formula like this: TRIM(TEXT(FIND("DUNS:", [EmailMessage].TextBody )+10))
But it just gets the: 12
Does anyone know how to do it?
I need to get an information from an Inbound email and set it in a field.
The information always will look as: DUNS: 123456789
I want to do it with a Process Builder, with a immediate action "Update Record". I am trying to fill up the field with the 9 numbers, but I don´t know how to do get the strings.
I did a Formula like this: TRIM(TEXT(FIND("DUNS:", [EmailMessage].TextBody )+10))
But it just gets the: 12
Does anyone know how to do it?
MID( TEXT([EmailMessage].TextBody) , FIND("DUNS:", [EmailMessage].TextBody+6 ) , 9)
i.e trying to achieve it with the MID function - MID(text, start_num, num_chars)
All Answers
TRIM(MID([EmailMessage].TextBody, FIND("DUNS:", [EmailMessage].TextBody )+5,10))
MID( TEXT([EmailMessage].TextBody) , FIND("DUNS:", [EmailMessage].TextBody+6 ) , 9)
i.e trying to achieve it with the MID function - MID(text, start_num, num_chars)