Expand my Community achievements bar.

SOLVED

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

Avatar

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

Avatar

Correct answer by
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

2 Replies

Avatar

Employee Advisor

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!

Avatar

Correct answer by
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