Here is my solution for creating a company email automatically from the existing last name field and the first name field (e.g. for address lists).
Input:
first_name: “John”
last _name: “Müller”
fx - formula column [with German umlauts]:
substitute(substitute(substitute(lower({first_name:} & “.” & {last _name} & “@yourdomain.com”), “ä” , “ae”), “ü”, “ue”), “ö”, “oe”)
Output:
email: “john.mueller@youdomain.com”
rdb
2
Thanks for your contribution. I allowed myself to reformat your post minimally.
TOMO
3
I think the “ß” is missing (for example like in “Waßmüller”) and you still will run in problems with non german names like André.
Thomas1
4
Thank You! Here ist a solution:
substitute(substitute(substitute(substitute(substitute(lower({first_name} & "." & {last_name} & "@yourdomain.com"), "ä" ,"ae"), "ü", "ue"), "ö", "oe"), "ß", "ss"), "é", "e")

system
Closed
5
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.