Control (Line Feed Character) in a data

SenthilD · 05-09-2020 07:39 AM

Hello,

In a QRCode scanning, it returns like

“SERVO- Mechanic Parisu Darbar
SUPER MG 20W40 (7494) - 7.5 Ltrs
Points - 150”

This is the key to search the master data in a table. But its unable to pick up the data though its available.

Please advise.

Regards,
Senthil

Steve

What does the stored value look like? How is it that the stored value is different from the scanned value?

SenthilD

I checked the excel sheet, both looks similar. The excel text comparison function also returns true.

Steve

Please provide screenshots of the following:

Configuration screen of the column receiving the scanned QR code.
Configuration screen of the column containing the stored values.
Entire expression used to match the scanned value to stored values.

SenthilD

Thanks @Steve, Given below the requested details & screenshot. That data field is a key column, so not expressing. Sample data is given below

“SERVO- Mechanic Parisu Darbar
TRACTOR OIL PLUS 15W40 - 7.5 Ltrs
Points - 150”

Steve

Both columns should be the LongText type, not Text.

SenthilD

I tried this option already, the following exception thrown

Column Name ‘UID’ in Schema ‘mechanicMaster_Schema’ cannot be scanned (not Barcode scannable) because its Column Type is ‘LongText’.MORE INFO

Steve

Then I’m out of ideas! I encourage you to engage support@appsheet.com for further help.

SenthilD

Thanks @Steve, Will do

hru

Hi @SenthilD, I am still learning this barcoding and I saw this post.

Just asking if actually your Key column is a multi-line text? As I saw your post that twice:

What if you make it like:

SERVO- Mechanic Parisu Darbar SUPER MG 20W40 (7494) - 7.5 Ltrs Points - 150

So that it will find only “One string”?

SenthilD

Hey @Heru, thanks. its a multiline text. The problem is, vendor has configured the coupon QR code that way. So I didn’t have a choice. Now I’m using a workaround, string tokenisers to extract the required data out of it and posting into table.