Personalization: convert from Upper case to Lower case in ACS

alicep47308254

30-10-2017

Hello Team,

I have a problem with the Field First Name.

The Database that I imported is made with all the First Names in Upper Case.

When I want to personalize the object is not good to see "Hello ALICE, we miss you"

There is a formula to change in a personalized fields from Upper Case to Lower Case directly in ACS?

Regards

Alice

Accepted Solutions (1)

Accepted Solutions (1)

Adhiyan

Employee

30-10-2017

Hey Alice,

This can be done in a workflow directly. In the query activity you use for targeting , you can form an expression Lower(@firstName) or Smart(@firstName) to convert the Upper case names to lower or Smart case .

You simply need to add the firstName as an additional field like this :

1337020_pastedImage_0.png

Then use the targetData personalization field to use this converted value in delivery personalization.

Alternately , you can query the whole Profiles table and update the first name using the same logic using a Query and Data update activity like mentioned over here : https://docs.campaign.adobe.com/doc/standard/en/AUT_Workflow_general_operation_Using_workflow_data.h...

https://docs.campaign.adobe.com/doc/standard/en/AUT_Workflow_general_operation_Using_workflow_data.h...

Regards,

Adhiyan

Answers (2)

Answers (2)

Adhiyan

Employee

30-10-2017

Hello Alice,

There is no wiki as such but you can explore the complete expression editor from here :

1337159_pastedImage_0.png

The functions are common for most databases and can be used in ACS to perform changes in how data is manipulated.

Regards,

Adhiyan