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 »

 
 Subscribe for updates via RSS or Email

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.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services