Force Upper Case

[Former Member]

Dear Folks,

Is there any way to force the end user to put upper case only in a text field ??

Thanks in advance,

[Former Member]

THanks guys

[Former Member]

But both above solution will only restrict while importing data thru import manager and after loading data validation will thro error message that is lower case.

Is ther any other alternate solution to restrict while entering itself (Manual in data manager or thru portal)

Thanks again

[former_member189669]

Hi Ferose,

The solution proposed by me has to be setup and executed in Datamanager .

A new validation has to be created in Datamanager >Validation tab . Set the expression as mentioned earlier and it works as you are expecting.

Regards,

Vinay M.S

[Former Member]

Hi Ferose,

You can have an assignment as

UPPER(Field_Name) and assign this to the Field_Name.

Execution of this assignment in your workflow ( if you have ) will make the values to upper case.

Or else if you want to restrict while entering itself you can follow the method as Vinay Suggested.

Hope it helps.

Regards,

Nimal

[former_member189669]

Hi Ferose,

Enforce a validation in Datamanager.

In Validation tab > Use validation expression - IS_UPPER(Field Name).

Set Automatic execution to Error. Input a meaningful message.

Regards,

Vinay M.S

[former_member208981]

Hi Ferose,

You can do the below.. if the requirement is that the data in Data manager should be in Upper case only:

In the import map, for the particular field.. Right click-> Set value conversion filter -> Change case -> Upper case.

Save the map and use it.

Even if the user enters in small case, in data manager it will be saved in Upper case only.

Hope it helps.

Thanks,

Priti