+4Hi,
I read a field from a custom object that has two email addresses separated by a comma and a space.
“xyz@func.com, wrt@func.com”
I need to get each email address and send an email.
I am new to this so any suggestions are welcome.
I think I may need to do two expression, one to extract each email
-R
Best answer by Rizwan322
To extract two email addresses from a field in a custom object using a reader and expression builder:
1. **Use the Reader**: Access the field in the custom object that contains the email addresses.
2. **Apply Expression Builder**:
- For the first email: Use a regex or string function to extract the first email address.
- For the second email: Apply a similar regex or string function to extract the second email address.
Example regex for extracting emails:
- First email: `(\S+@\S+\.\S+)`
- Second email: Use appropriate logic to handle the position or delimiter if the emails are separated.
+14Yes, you need to use expressions to do it.
+2To extract two email addresses from a field in a custom object using a reader and expression builder:
1. **Use the Reader**: Access the field in the custom object that contains the email addresses.
2. **Apply Expression Builder**:
- For the first email: Use a regex or string function to extract the first email address.
- For the second email: Apply a similar regex or string function to extract the second email address.
Example regex for extracting emails:
- First email: `(\S+@\S+\.\S+)`
- Second email: Use appropriate logic to handle the position or delimiter if the emails are separated.
+4I did it like this as I am not a regex expert.
substring( {{R3.passthrough}},0,indexOf({{R3.passthrough}}, ',',0)) for the first one, then
substring( {{R3.passthrough}}, indexOf( {{R3.passthrough}}, ',',0 )+2, length( {{R3.passthrough}}))
I have control over the passthrough string so I know it is always “x@y.com, z@x.com”
Thank you to everyone for replaying so swiftly.
+4Update, i did fall back to using the suggested regex to make it easier and work
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
