Convert field value to upper case or lower case in InfoPath in SharePoint 2013

This InfoPath SharePoint 2013 tutorial explains, how we can convert field value to lower case or upper case in InfoPath 2013 in SharePoint 2013. Also, we will discuss how to convert to upper case using Rules in InfoPath 2013 in SharePoint 2013/Online. How to convert to lower case using rules in SharePoint 2013/Online in InfoPath 2013. I will also show how to convert the first letter to UPPER case in InfoPath 2013.

Recently while working in an InfoPath form for SharePoint 2013, I got a requirement like whenever a user enters something in a textbox, the value should be converted to upper case letter.

We can convert to different cases without using a code, by simply writing a rule in InfoPath in SharePoint 2013.

So you can add a rule and write the below expression according to your requirement:

Convert To UPPER case in InfoPath 2013

Below is the InfoPath rule to convert to Upper Case in SharePoint 2013 InfoPath form. The rule you can write in the particular field on which you want to convert to upper case.

If you are new to InfoPath 2013 rules, read an article on InfoPath 2013 show hide section using Rules in SharePoint online.

translate(my:FieldName, “abcdefghijklmnopqrstuvwyxz”, “ABCDEFGHIJKLMNOPQRSTUVWYXZ”)

Convert to lower case in InfoPath 2013

Below is the InfoPath rule to convert to lower case in SharePoint 2013 InfoPath form.

translate(my:FieldName, “ABCDEFGHIJKLMNOPQRSTUVWYXZ”, “abcdefghijklmnopqrstuvwyxz”)

Convert the first letter to UPPER case in InfoPath 2013

Below is the InfoPath rule to convert to the first letter to Upper Case in SharePoint 2013 InfoPath form.

concat(substring(translate(my:FieldName, “abcdefghijklmnopqrstuvwxyz”, “ABCDEFGHIJKLMNOPQRSTUVWXYZ”), 1, 1), substring(my:FieldName, 2, string-length(my:FieldName) – 1))

Convert field value to upper case or lower case in InfoPath in SharePoint 2013

Convert field value to upper case or lower case in InfoPath in SharePoint 2013

You may like following InfoPath SharePoint 2013 tutorials:

Hope this will work for you to convert field value to the upper case, lower case or first letter upper case using rules in InfoPath 2013 in SharePoint 2013/2016 or SharePoint Online.

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

>