Tell the users to stop copying and pasting from excel by single clicking a cell to select it. Excel appends a carriage return and line feed to the pasted value when you select a cell and copy the value. You can however double click a cell and then select the value to be copied from within the cell or formula bar and copy that value without the carriage return and line feed being included.
To locate the records that have the a carriage return and/or line feed, use crystal reports with a record selection on the field, such as item code or lot/serial number. Should look something like this.
{CI_Item.ItemCode} Like "*" + Chr(13) + "*"
Or
{CI_Item.ItemCode} Like "*" + Chr(10) + "*"
You can also add a formula to the report to replace the characters with something else. IIRC, the exact value should be stored in sage 100 as a carriage return followed by a line feed even though DFDM displays it as the squiggly B (beta symbol I think), so use Chr(13) + Chr(10) in a replace function or in the odd case where only one of the two exists, use two nested replace functions, one for each character. As for the replacement character, use either a single character that you are sure doesn't occur within their data or a combination of characters that you are positive would never occur in their data.
------------------------------
David Speck II
Tennessee Software Solutions
------------------------------
Original Message:
Sent: 04-14-2020 18:10
From: Beth Bowers
Subject: Extract Item Serials with invalid characters
Both. :-) I'm pretty sure he has a posting on here, which he reminded me of, but gave me an extra little boost. If I could remember the darned client, I could do look up my emails on it. Let me ponder while I cook dinner.
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------
Original Message:
Sent: 04-14-2020 17:33
From: Nancy Hanson
Subject: Extract Item Serials with invalid characters
On 90minds or privately? In other words, can I search for it in 90minds?
------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
Original Message:
Sent: 04-14-2020 16:53
From: Beth Bowers
Subject: Extract Item Serials with invalid characters
@Nancy Hanson -@David Speck II helped me with that issue a couple of weeks ago.
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625