A good way to import line breaks from Excel?

Kinetic ERP
1

Hello,

I am loading data for a custom part description field from Excel. The descriptions contains line breaks. The data imports without error but I’ve been told that it’s an unprintable character and is causing occasional problems.

We need the line breaks. Is there something I can replace the char(10) with in Excel, or do we have to manually enter the correct line breaks in Epicor afterwards? I’m hoping it’s the former.

Thank you

2

Are you trying to view the line breaks in an Epicor form? Or on a printed SSRS form?

3

Both. The sales people check it on the screen to make sure it looks as it should, then it will be printed with the line breaks on the Purchase Order report

4

I know on the SSRS side of things I’ve used the below expression to “replace” chr(10) and/or chr(13) with the more supported “VbCrLf”… which then should print your line breaks correctly.

=First(REPLACE(Fields!CommentText.Value, chr(13), VbCrLf))

5

The issue is that although it appears to work on screen it’s causing problems in places like doing a Receipt Entry, so I’m wondering if there’s a way to get the data clean in the fields themselves.