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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

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

PrateekWadhwa
Level 1
Level 1

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

 

1 Accepted Solution
PrateekWadhwa
Correct answer by
Level 1
Level 1

Hi Kishor,

 

Thank you, I took the other approach and got it working, I am sending data in HTML format and importing into AC as an HTML Field and directly using it in targetdata.

 

Thanks again for your response, I would try this as well.

 

Regards

Prateek Wadhwa

View solution in original post

0 Replies
kishorep
Employee
Employee

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!

PrateekWadhwa
Correct answer by
Level 1
Level 1

Hi Kishor,

 

Thank you, I took the other approach and got it working, I am sending data in HTML format and importing into AC as an HTML Field and directly using it in targetdata.

 

Thanks again for your response, I would try this as well.

 

Regards

Prateek Wadhwa

View solution in original post