InfoPath Dev

Here ya go.

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

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

 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)

 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 

substring-after(field, '\')

 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?

 

 

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

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'.")

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

Thanks heaps Jimmy, much appreciated.

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

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)

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|[email protected]

Cheers

Dave

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

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

 Cheers Dave