Controls

Re: Concat string help [SOLVED]

davedmonds — Mon, 08 Sep 2014 09:29:41 GMT

Hi I wonder if you would be able to point me in the right direction for copying just the email address out of a string in the following format:

i:0#.f|membership|12345@example.com

Cheers

Dave

Update, I used the following code to achieve the desired result:

substring-after(temp email, "i:0#.f|membership|")

Cheers Dave

Re: Concat string help

Jimmy — Tue, 12 Jun 2012 17:20:37 GMT

I think your best option is to have 4 textboxes with colons in between them, and then set the textboxes to limit to 2 characters and move to the next control when the 2 character limit is reached.

On top of that, you can add a hidden 5th field whose default value formula is something like: concat(firstPart, ':', secondPart, ':', thirdPart, ':', fourthPart)

Re: Concat string help

nadavturgeman — Tue, 12 Jun 2012 11:56:13 GMT

Hi Please help me

How can i create infopath field which has template on it? for example: i want this template:

00:00:00:00

and i want the client just to type the digits without the":" between.

to get this result :

12:34:24:65

the client has to type just:

12342465

and automatically on the form he will get in the field this template:

00:00:00:00

thanks

Re: Concat string help

sudlev — Tue, 15 Nov 2011 21:49:40 GMT

I didn't think to try that, works a treat!

Thanks heaps Jimmy, much appreciated.

Re: Concat string help

Jimmy — Tue, 15 Nov 2011 08:06:00 GMT

If you want to have double quotes in your string, use single quotes for the beginning and end of the string:

concat("This string has ", 'some "double quotes" and ', "some 'single quotes'.")

Re: Concat string help

sudlev — Tue, 15 Nov 2011 03:56:07 GMT

Hi Ernesto,

Did you manage to find a way to include a double quote in a string? I am also trying to dynamically create a query but don't know how to include the double quotes. I changed all the double quotes to single and this worked but I'm not sure if this causes any problems down the track.

Danny

Re: Concat string help

andyoye — Tue, 01 Jun 2010 12:37:42 GMT

Thanks, I used

eval(eval(Person, 'concat(substring-after(my:AccountId, "\"), "; ")'), "..") to loop through to get User IDs. Now the text box holds i.e: tim; tom; jerry

How can I strip them out and assign to sperate textboxes? txtBox1 should holds tim, txtBox2 holds tom and txtBox3 holds jerry?

Re: Concat string help

Jimmy — Sat, 29 May 2010 01:54:11 GMT

substring-after(field, '\')

Re: Concat string help

andyoye — Fri, 28 May 2010 20:14:06 GMT

I have a Contact Selector control. I would like to extract the "AccountId"s out to text boxes. i.e Contact Selector has domain\userA; domain\userB

I would like textBox1= userA and textBox2= userB

Thanks

Re: Concat string help

Qazi Anis — Fri, 25 Sep 2009 15:30:16 GMT

as per my understanding u have first name as firstname+2lettercountry code and you need to get firstname only. let firstnamep be the field having value = firstname+2 letter country code

substring(firstnamep,1,length(firstnamep) - 2)

Re: Concat string help

apgcng — Tue, 16 Jun 2009 06:51:14 GMT

thanks mate! I did my own hack which separately parsed out the names but this method is much better. thanks again.

Re: Concat string help

Clay Fox — Tue, 16 Jun 2009 06:44:12 GMT

Here ya go.

concat(substring-before(substring-after(substring-after(displayname, ","), " "), " "), ".", substring-before(displayname, ","), "@domain.com")

Re: Concat string help

apgcng — Mon, 15 Jun 2009 08:19:12 GMT

Hi, I have a similar issue

Displayname is Lastname, Firstname (XX)

Need to parse out the email address - Firstname.Lastname@domain.com

Got most of it working from the posts here but now need to parse out firstname without the (XX) (note that XX is a two character country code)

Re: Concat string help

Alec Pojidaev — Thu, 15 Jan 2009 19:40:02 GMT

The LastName and FirstName are your hidden fields they are not part of the formula. And here are the expressions to set your hidden fields to the new values. You will need two separate actions for each of your field.

substring-before(DisplayName," ") - which is to get the last name...

substring-after(DisplayName," ") - to get the first name

Re: Concat string help

nwade — Thu, 15 Jan 2009 19:04:20 GMT

Hi Alec,

Could you help me by maybe filling in the blanks for me....I'm a rookie at all of this just trying stuff as I go. Unfortunately not a lot of it makes sense to me:

so per your suggestion I should have the following?
concat(translate(substring-before(DisplayName," "))) - which is to get the last name...and then a separate one:
concat(translate(substring-before(DisplayName," "))) - to get the first name....but how would I go about putting them together.

I tried applying your response and the forumla checker kept erroring on the "LastName" and "FirstName" parts.