Scanner does not detect embedded CR

George Fontes

• September 15, 2020 22:03

Hi,

I'm using Data Matrix and trying to embed a carriage return in my data so when scanning into an excel or word document, all the data is not entered into one cell or line.

I'm using <<CR>> from the Control Characters panel between data elements, but it appears not to be recognized by the scanner..

My symbology settings are:

Symbol type: ECC 200

Use ECI Protocal

Text Encoding: US, Western Europe

Prefix: None

Size: Auto - square

Any recommendations would be appreciated.

Thank You,

George

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • September 16, 2020 17:00

  I think it could be a setting in the scanner that needs enabling as sometimes Excel will not pick up these characters. Trying scanning into Notepad and see if that picks up the encoded symbol as that is less forgiving. If not look to see if you can see something like USB Keyboard Emulation or Function Key Mapping for your scanner config and try enabling that. 

  0
• 

  George Fontes

  ★ BarTender Hero ★

  • October 26, 2020 18:52

  Thanks Pete,

  Scanning in Notepad picks up the CR, but not in excel, it puts the data in one cell with colons before ever dtata element.

  Thank you,

  george

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • October 27, 2020 00:30

  Have you tried replacing the CR with a TAB instead ?

  0

Please sign in to leave a comment.