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

[PrateekWadhwa]

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. 

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.

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.

Regards

Prateek

[Kishore_Padamata]

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 · Accepted solution]

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