InfoPath Dev

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

 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. 

 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.

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

Have a great day!

Best Regards,