IDC - STRJOIN Function Question: Add a Line Break?

ECM
1

For anyone who works with Epicor IDC DFD mappings: The STRJOIN function can be used in a field formula to concatenate things. I’m using a STRJOIN function for a MultiLine field.

Q: Does anyone know if it’s possible to add a line break within a STRJOIN function?

2

I might try the “\n\r” in the join. It’s the standard escape-character sequence for newline/return.

3

Thanks for the suggestion. Didn’t work in the IDC DFD function. But my professional services partner will be asking Ancora if there is syntax for their STRJOIN function to add a Line Break. If there is, then I’ll share with the group.

2 Likes
4

Ancora provided a solution! In the STRJOIN, insert: SQLEXEC(STRJOIN(“select char(13) + char(10)”))

So if I had an IDC DFD MultiLine field and wanted to concatenate the values from the CUSTOMER_NAME and CUSTOMER_ADDRESS fields with a Line Break in-between, the STRJOIN formula would be:

STRJOIN(CUSTOMER_NAME,SQLEXEC(STRJOIN(“select char(13) + char(10)”)),CUSTOMER_ADDRESS)

1 Like