Trying to print an address
from a Saved Search to ...
# suitescripta
alien4u
05/31/2019, 7:23 PMTrying to print an address
from a Saved Search to an Advanced PDF Template and I don’t get break lines… the whole address is one line…
I tried:
${result.address_field?replace('\r\n','<br />','r')}${result.address_field?replace("/\r\n/g","<br />","r")}REGEXP_REPLACE({address_field}, '/[\r\n]/g','<br />')REGEXP_REPLACE({address_field}, '/[\r\n]/g','nl')t
TJ Cornelius
05/31/2019, 7:28 PM@alien4u I've run into that before. Here is what I do to solve that issue:
//format address with line breaks
var addressArray = (customerAddress.split(/\n/g) || []);
var addressArrayCount = addressArray.length;
var refinedAddress = '';
for (var ra = 0; ra < addressArrayCount; ra++) {
refinedAddress += (addressArray[ra] + "<br\/>");
}
TJ Cornelius
05/31/2019, 7:29 PMcustomerAddress is the address I got from the search
TJ Cornelius
05/31/2019, 7:30 PMrefinedAddress is the end result to use in the PDF template
a
alien4u
05/31/2019, 7:31 PMI solved that in script before but here is a search directly going to advanced pdf template…
t
TJ Cornelius
05/31/2019, 7:40 PMah, got it.
a
alien4u
05/31/2019, 7:46 PMI got it working… thanks…
t
TJ Cornelius
05/31/2019, 7:47 PMGreat!
j
jen
05/31/2019, 8:09 PM@alien4u what was your solution?
a
alien4u
05/31/2019, 8:11 PMIn the related search a formula text:
TRANSLATE({address_field}, chr(10), '|')${result.formulatext?replace("|","<br />")}