Extract text from QR Code

[Te_Arawa_71]

Hi,

I have been trying to extract text from a QR scan of a Contact vCard. I would like to be able to create a contact record based on the QR data. I didn’t think there is an existing way to do this so I’ve dived into trying to do this myself.

I’ve copied the “raw” data below.

QR Code

BEGIN:VCARD
VERSION:3.0
N:Jordan;Michael
FN:Michael Jordan
ADR:;;;Chicago;Illinois;;United States
TEL;CELL:12345678
EMAIL;WORK;INTERNET:airjordan@gmail.com
END:VCARD

QR Code 2

BEGIN:VCARD
VERSION:3.0
N:Johnson;Magic
ORG:LA Lakers
EMAIL;TYPE=INTERNET:mj@gmail.com
TEL;TYPE=CELL:021 1234567
TEL:03 1234567
ADR:;;Hollywood Ave;Los Angeles;9010;USA
END:VCARD

I have been trying INDEX, SPLIT, LEFT, FIND expression but the SPLIT function seem to be based on a sequence / order and created an error when I tried a different QR codes (that used a different order).
What’s more, I could not come to grips with the LEFT, RIGHT, FIND syntax so am calling out for some help / guidance.

What I have noticed with the two different QR codes is they use similar “labels”. To me a label is anything preceding the colon (:). The N, FN, ADR, ORG, CELL… etc and the data to the right of the label is the text I would like to capture. Excuse me if I have the wrong terminology Label.

Is there an easy way to extract the data based on say the “Label”?

Thanks in advance,

Regards
Te Arawa