CODEWITHSUNDEEP
excelcsvadobe-indesignvcf-vcard
sam_slvr
sam_slvr

Reputation: 1

BATCH GENERATE QR USING VCARD METADATA

I want to create QR from vcard metadata and recently I found video that explains batch create multiple QR at once (https://youtu.be/t7xV1DXNM8Y?t=793). But in the tutorial he doesn't explains how he generated vcard metaddata in to one line. I have a excel sheet that contains data and I want to converted them into vcard metadata.

When I'm converted the excel data in to vcard I get below output. (Figure 1)

Figure 1 - vCard Standard Format

Is it possible to get above output into one line (Figure 2)

Figure 2 - Needed Format

I want to automate these process and is there any detailed guide to this.

If there's any alternative way to do this point them out.

Upvotes: 0

Views: 1286

Answers (1)

Yuri Khristich
Yuri Khristich

Reputation: 14537

Probably you can use the Excel formula TEXTJOIN()

Something about this:

=TEXTJOIN("",true,"BEGIN:VCARD\nVERSION:",A1,"\nN:",B1,"\nORG:",C1,"\nEND:VCARD")

Upvotes: 0

Related Questions