infopath Usefull Function's for sharepoint

-


substring-before():
Syntax: substring-before(field1,field2)
Her it will return the text presented in field1 that precedes the first occurrence of field2.

Example:
substring-before("ABC PQR"," ") will return "ABC". Here we are doing string manipulation based on blank space.

Similarly substring-after("ABC PQR "," ") will return "PQR"
sbustring("ABC",1,1) - This will return "A".
Replace blank spaces with underscores (_). I was just thinking if there is any direct function for replace which was not there.The way I did by using the translate function. Open the Insert Formula dialog box (Open the Rule Details dialogbox and then click on fx in the Value textbox).

Then in the Insert Formula write the function like below:
translate(Title," ","_").

Convert To UPPER case:
translate(my:FieldName, "abcdefghijklmnopqrstuvwyxz", "ABCDEFGHIJKLMNOPQRSTUVWYXZ")

Convert to lower case:
translate(my:FieldName, "ABCDEFGHIJKLMNOPQRSTUVWYXZ", "abcdefghijklmnopqrstuvwyxz")

Convert first letter to UPPER case:
concat(substring(translate(my:FieldName, "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 1, 1), substring(my:FieldName, 2, string-length(my:FieldName) - 1))

Check Length in Custom Rule in

string-length(translate(., "()- ", "")) = 10

Comments

Post a Comment

Popular posts from this blog

WCF interview questions

-
Windows Communication Foundation is... Some Important points I have collected from MSDN site are: A part of the .NET Framework that provides a unified programming model for rapidly building service-oriented applications that communicate across the web and the enterprise. The global acceptance of Web services, which includes standard protocols for application-to-application communication, has changed software development. For example, the functions that Web services now provide include security, distributed transaction coordination, and reliable communication. The benefits of the changes in Web services should be reflected in the tools and technologies that developers use. Windows Communication Foundation (WCF) is designed to offer a manageable approach to distributed computing, broad interoperability, and direct support for service orientation. WCF simplifies development of connected applications through a new service-oriented programming model. WCF supports many styles of...
Read more

The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or operable program

-
Following worked for me: Uninstall the previously installed ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. Install 64-bit versions of ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. https://littletalk.wordpress.com/2013/09/23/install-and-configure-the-office-365-powershell-cmdlets/ If you get the following error  In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer , then install the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:  http://www.microsoft.com/en-us/download/details.aspx?id=39267 Copy the folders called MSOnline and MSOnline Extended from the source C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ to the folder C:\Windows\SysWOW64\WindowsPowerShell\v1.0...
Read more

what is Event Cache table in sharepoint

-
Every Content database in SharePoint Contains an EventCache table that is the change log for objects contained in the database. Each row in this table is depicting a change in an object where columns usually contain information such as the date and time of a change, the type of object that was changed, the nature of the change, and a unique identifier for the object. EventCache table is important because it stores the list of site events for which users might have requested alerts.
Read more