I have been using PHP QR Code (http://phpqrcode.sourceforge.net/) to create QR barcodes. Each barcode contains several different pieces of information that I concatenate into a single string. The reason I am doing this is because the label I have to print on is too small to make separate barcodes for each piece of information.
$PartNumber = '12345';
$UIN = 'ABCD';
$IMEI = 00001;
$WHSE = 'AAA';
$Barcode = $PartNumber.$UIN.$IMEI.$WHSE;
QRcode::png($Barcode, 'Barcode.png');
This part works perfectly fine. I print the barcode and then scan it into Excel and I get a string that reads '12345ABCD00001AAA'. What I want to be able to do is put the ASCII code for the Tab button in between each variable so that when I scan the barcode into Excel, each variable will be in a different column.
$PartNumber = '12345';
$UIN = 'ABCD';
$IMEI = 00001;
$WHSE = 'AAA';
$Barcode = $PartNumber.'\09'.$UIN.'\09'.$IMEI.'\09'.$WHSE;
QRcode::png($Barcode, 'Barcode.png');
So the result would be Cell A1 = '12345', B1 = 'ABCD', C1 = '00001', D1 = 'AAA'.
However, when I scan the barcode into Excel the whole string is placed in cell A1. I can hear Excel dinging as if it doesn't like the ASCII value and then seems to ignore it. I would prefer not to have to use code in Excel to separate the string based on a delimiter that I add.
Does anyone know how I can get each variable into it's own column, or if it's even possible to do?