Ben
|
Best Answer
The data returned from the encoder file does actually return the full string, the problem is the CSV format.
Since the data includes a carriage return and a line feed at the end of each line, the CSV format will clip this at the first line because multi-line values are not supported.
There may be a workaround by substituting another character for the carriage returns and line feeds, like a space. The best option would be to keep the file in Excel format if possible.
Example substituting a "." for the CHAR(13) carriage return and the "?" for the CHAR(10) line feed.
=SUBSTITUTE(SUBSTITUTE(EncDM("123"),CHAR(13),"."),CHAR(10),"?")
If you are generating other 2D Barcodes, use:
For PDF417:
=SUBSTITUTE(SUBSTITUTE(IDAutomation_PDF417("123"),CHAR(13),"."),CHAR(10),"?")
For QR Code:
=SUBSTITUTE(SUBSTITUTE(EncQR("123"),CHAR(13),". "),CHAR(10),"?")
For Aztec:
=SUBSTITUTE(SUBSTITUTE(EncAztec("123"),CHAR(13)," ."),CHAR(10),"?")
IDAutomation does not claim that this is a solution. However, if an application such as InDesign or Notepad can replace the "." and "?" with the carriage return and line feed, it might work.
Posted 12.3 year(s) ago
|