Line return in BAQ Calculated Field

Epicor ERP 10
1

Is it possible to put a line return in a calculated field in a BAQ? I have columns I am concatenating together but I want them to be multiline?
OrderHed.Company + ’ ’ + Customer.CustID + ’ ’ + Customer.Address1 + ’ ’ + Customer.Address2 + ’ ’ + Customer.Address3 + ’ ’ + Customer.City

2

Maybe, haven’t tried it

3

some of the later posts of the following thread may help:

4

One warning … You might run into issues when exporting. Maybe make a hidden calculated field that is just your calculated multi-line feild, with a substitute() call. Like

substitute(multilineAddress,"\r\n","|");

Ideally, nest several substitute() calls, to convert all combinations of \n and \r, and other export unfriendly characters

substitute(substitute(substitute(substitute(substitute(multilineAddress,"\r\n","|"),"\n\r","|"),"\n","|"), "\r","|"), "\t", "     ")