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(), "-"),
"-"))