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

swathip — Wed, 13 May 2009 05:17:33 GMT

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)))

Converting Upper Case to Lower case characters in a field

lou131 — Tue, 12 May 2009 16:43:17 GMT

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

General

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

Converting Upper Case to Lower case characters in a field