How to change all values of a field into InitCap

[Former Member]

Hi Gurus,

I got one requirements where i need to change all the customer names to InitCap at a time i.e all the first characters should be uppercases and rest should in lower. But i couldnt find any such functions in expression editor. Can anybody clear that issue.

Regards

Santosh

[Former Member · Accepted solution]

Hi Yugandher,

In the Import Manager,after mapping the customer name, right click on the source field.

Go to the set value conversion filter->Change Case->Title Case.

Hope it helps.

Thanks,

Minaz

[Former Member]

Hi,

Kindly update us on your issue.

Regards,

Jitesh Talreja

[Former Member]

Hi,

If you have already imported the records then the functionality you are looking for is not avaialble but you can either convert all the values in either Upper case or Lower Case using assignment with expression Lower(fieldname) or Upper(fieldname). But you want Title Case only then import the customername along with some unique field along with the option suggested by Minaz n Priti and update the existing records.

Regards,

Jitesh Talreja

[former_member208981]

Hi Ravi,

Please follow the below steps:

1. Import the data and Map the Fields in Import Manager

2. Under Value Conversion and Mapping-> Source Values-> Right Click on the value-> Change Case-> Title Case

3. Do the Value mapping

Hope it helps.

Thank you,

Priti