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

Loading Carriage Return, No fixed width spaces in Adobe Campaign List/Schema to populate in Delivery

Avatar

Avatar
Level 1
PrateekWadhwa
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
PrateekWadhwa
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
View profile
PrateekWadhwa
Level 1

19-07-2021

Hi Team,

 

I need quick help with one of the requirements, I have a Data file coming with a Carriage return, one of the fields as in the screenshot will have data with the spaces in it, No fixed width Could be a space generated due to wrap text as well. 

 

PrateekWadhwa_0-1626744606936.png

 

 

Our requirement is to load the file as it is in the Adobe Campaign list and display data in the Adobe campaign as it is displayed in the file and use that data in a workflow to be sent out in email delivery. But unfortunately, the Adobe campaign does not display data in this format even if I use a new data scheme, with a String or memo field.

 

Also, when I try to send the data in delivery, it does not reflect any spaces as in the screenshots below.

 

PrateekWadhwa_1-1626744641248.png

 

 

Could anyone help me here if you are aware of any scenario that can help me find a solution for this? I used out-of-the-box schema attributes as well like the Comment field of Recipient schema but still, the data does not populate with spaces in delivery.

 

PrateekWadhwa_2-1626744662995.pngPrateekWadhwa_3-1626744677374.png

Regards

Prateek

 

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 5
Employee
kishorep
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

3 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile

Avatar
Boost 5
Employee
kishorep
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

3 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Affirm 3
Affirm 1
View profile
kishorep
Employee

22-07-2021

Hello Prateek

Please try below in Delivery:
<%
var actualText = targetData.<ColumnName>;
var customText = actualText.replace(/[\r\n\x0B\x0C\u0085\u2028\u2029]+/g,"<br />");
%>

Will replace the line breaks with HTML breaks.
Hope this helps!