Concatinate a portion of two fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smonczka - 06 Apr 2006 20:25 GMT

I am making an employee form that combines the first letter of the
first name and the last name to create an email address for a new
employee. For example John (field1), Smith (field2) would equel
jsmith@mycompany.com (field3). Thanks to a responce from another user
in the group I now understand how to use Concat to add the field2 and
"@mycompany.com. But, using a formula how do I only pull out the
first letter of the first name. Is there something, like excels MID or
Left function in InfoPath.

Also is there a full list of discriptions of InfoPath Functions
somewhere on the Internet?

Thanks all for your help.

Steve

Reply to this Message

S.Y.M. Wong-A-Ton - 07 Apr 2006 08:54 GMT

For a full list of descriptions of functions, use InfoPath's help and search
on "About formulas and functions", or just click on the function name when
you are in the "Insert Function" dialog box and look at the description below
the list of functions.

To solve your challenge, use the following formula for field3:

concat(substring(field1, 1, 1), field2, "@mycompany.com")

To get letters in lower case, use the translate() function as demonstrated
in this solution:
http://enterprise-solutions.swits.net/infopath/convert-first-letter-word-upper-c
ase.htm but then switch "ABC..." and "abc..." around.
---
S.Y.M. Wong-A-Ton

> I am making an employee form that combines the first letter of the
> first name and the last name to create an email address for a new
[quoted text clipped - 11 lines]
>
> Steve

Reply to this Message

smonczka - 10 Apr 2006 17:33 GMT

S.Y.M.

Thank you for your explination. It was exactly what I needed.

Reply to this Message

smonczka - 10 Apr 2006 17:33 GMT

S.Y.M.

Thank you for your explination. It was exactly what I needed.

Reply to this Message