Converting Upper Case to Lower case characters in a field - InfoPath Dev
in

InfoPath Dev

Converting Upper Case to Lower case characters in a field

Last post 05-12-2009 10:17 PM by swathip. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-12-2009 09:43 AM

    • lou131
    • Top 100 Contributor
    • Joined on 02-13-2007
    • USA
    • Posts 89

    Converting Upper Case to Lower case characters in a field

    Hi,

    I need to know a function command that can convert the first character in a field to lowercase or uppercase.

    Any help is appreciated.

    Thanks

    Lou

  • 05-12-2009 10:17 PM In reply to

    Re: Converting Upper Case to Lower case characters in a field

     

    Hi,

    By using translate, concat, substring functions you can achieve your requirement.

    The following will translate the value of field1 as you required.

    For example, field1 value = lower case and the out put is = Lower case

    Here I have used the following expression as default value in the field2.

    concat(translate(substring(../my:field1, 1, 1), "abcdefghijklmnopqrstuvwxyz", "ABCDEFGHIJKLMNOPQRSTUVWXYZ"), substring(../my:field1, 2, string-length(../my:field1)))

    Swathip
    www.ggktech.com
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.