Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Personalization: convert from Upper case to Lower case in ACS

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

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)

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct Reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct Reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
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)

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct Reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct Reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
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

Avatar

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

30-10-2017

Hello Adhiyan,

there are some Wikis for all the Expression Editor that I can find in ACS?

Regards

Alice