General

Re: Concat String Name

Evanz — Tue, 01 Dec 2020 17:44:49 GMT

Awesome. Thank you very much for your quick turnaround! You're the best. :-)

Have a great day!

Best Regards,

Re: Concat String Name

Hilary Stoupa — Tue, 01 Dec 2020 15:41:49 GMT

Here's a sample with just the initials part. Right click the attached file and save it locally. Right click the saved file and select Design to open in design mode.

Re: Concat String Name

Hilary Stoupa — Tue, 01 Dec 2020 15:39:05 GMT

I don't know if you need the translate, but this will get you the two initials in first last order:

concat(substring(substring-after(DisplayName, ", "), 1, 1), substring(DisplayName, 1, 1))

I'd probably wrap the translate around the above, so that you only have to have it one time. Then use another concat around that to add the date info you wish to include.

Concat String Name

Evanz — Tue, 01 Dec 2020 01:28:28 GMT

Hi,

I got this concat string code to work like B 372630 with the name Brown, Michael (LN, FN). It only shows the initial last name "B" but I can't get how to write an additional code to get the initial first name as well. For example, it should be like MB 372630. Any thought? Thank you so much!

concat(translate(substring(DisplayName, 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring-after(substring-before(DisplayName, "."), substring(DisplayName, 1, 1)), " ", translate(substring(substring-after(substring-before(DisplayName, "@"), "."), 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring-after(substring-after(substring-before(DisplayName, "@"), "."), substring(substring-after(substring-before(DisplayName, "@"), "."), 1, 1)), substring-before(substring-after(now(), ":"), ":"), substring-after(substring-after(now(), ":"), ":"), substring-after(substring-after(today(), "-"), "-"))