Forum Discussion
Helper ITwo improvements around email
Hi Kreg
You can achieve your goals by following these easy steps at PQ:
1. Split your name column by first space:2. Trim your columns
3. On your second column replace space by . ( space is just pressing space on keyboard)
4. Lowercase your profile column
* M language is case sensible5. Add custom Column with code:
if [Profile] = "pr" then [Name.1]&[Profile]&"."&[Name.2]&"." & " @comapny.com"
else
[Name.1]&"."&[Name.2]&"."& " @comapny.com"Result :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Super UserHi Kreg
You can achieve your goals by following these easy steps at PQ:
1. Split your name column by first space:
2. Trim your columns
3. On your second column replace space by . ( space is just pressing space on keyboard)
4. Lowercase your profile column
* M language is case sensible
5. Add custom Column with code:
if [Profile] = "pr" then [Name.1]&[Profile]&"."&[Name.2]&"." & " @comapny.com"
else
[Name.1]&"."&[Name.2]&"."& " @comapny.com"
Result :
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
KregRita, thanks again.
I saw one issue. With some non-English names it does not work. I mean for example two dotted above `a` and many more similar cases. When I manually set it to English `a` it works, but it should set upfront all such cases.
In transform table the best. I choose that method in fact, seems to be easier 🙂