InfoPath 2013 LEFT and RIGHT functions
Learn how to use the string-length and substring functions in InfoPath 2013 to simulate the functionality provided by the LEFT or the RIGHT function known from Excel or VB.
The LEFT function known in Excel or Visual Basic returns a leftmost specified amount of characters in a string, and the RIGHT function returns a rightmost specified amount of characters in a string.
While InfoPath does not have a LEFT or a RIGHT function you can use in formulas, you can combine existing functions such as the substring and string-length functions to provide the functionality that the LEFT and the RIGHT functions provide.
The following InfoPath 2013 video tutorial shows how you can construct a formula that makes use of the two aforementioned existing functions in InfoPath to simulate the functionality of the LEFT or the RIGHT function in InfoPath 2013.
In this InfoPath 2013 tutorial video, you learned...
- How to construct a formula that makes use of the substring function to simulate the LEFT function known from Excel or VB.
- How to construct a formula that makes use of the substring and string-length functions to simulate the RIGHT function known from Excel or VB.
See more InfoPath 2013 tutorial videos »
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.
Related InfoPath Articles:
- InfoPath substring-after and substring-before functions
- InfoPath 2010 functions within functions in a formula
- InfoPath eval and sum functions to get total length of strings in repeating table
- People picker data merging in InfoPath 2013
- Forcing users to select a particular day of the week from a date picker