Concat string help - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Concat string help

Last post 09-08-2014 02:29 AM by davedmonds. 26 replies.
Page 2 of 2 (27 items) < Previous 1 2
Sort Posts: Previous Next
  • 06-15-2009 11:44 PM In reply to

    Here ya go.

    concat(substring-before(substring-after(substring-after(displayname, ","), " "), " "), ".", substring-before(displayname, ","), "")

  • 06-15-2009 11:51 PM In reply to

    • apgcng
    • Not Ranked
    • Joined on 06-15-2009
    • Posts 2
    thanks mate! I did my own hack which separately parsed out the names but this method is much better. thanks again.
  • 09-25-2009 08:30 AM In reply to

     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)

    Qazi Anis
    Technical Architect
    Bitwise Inc
  • 05-28-2010 01:14 PM In reply to

     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


  • 05-28-2010 06:54 PM In reply to

    substring-after(field, '\')

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 06-01-2010 05:37 AM In reply to

     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?



  • 11-14-2011 07:56 PM In reply to

    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.


  • 11-15-2011 12:06 AM In reply to

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

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 11-15-2011 01:49 PM In reply to

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

    Thanks heaps Jimmy, much appreciated.

  • 06-12-2012 04:56 AM In reply to

    Hi Please help me

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


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

    to get this result :


    the client has to type just:


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



  • 06-12-2012 10:20 AM In reply to

    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)

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 09-08-2014 02:29 AM In reply to

    Re: Concat string help [SOLVED]

    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:




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

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

     Cheers Dave

Page 2 of 2 (27 items) < Previous 1 2
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.