Removing Special Characters and strings in Infopath Formula RRS feed

  • Question

  • Hi,

    In Textbox field i used "sharepointsiteurl" in formula,so i want to get only Title,how to trim the url to get Title

    eg:-  http://servername/test/test1

    Here in Textbox i wanted to show "test1"

    How can i do this

    Thank You

    Tuesday, March 22, 2011 1:25 PM


  • Since the site title is part of the site collection, you can use several functions to generate the title as shown:

    translate(substring-after(SharePointSiteCollectionUrl(), SharePointSiteUrl()), "/", "")

    The substring-after() will give you /test1 and then the translate() removes the slash.


    Monday, March 28, 2011 6:45 PM