Import VCard (.vcf) file

If I was doing this I would use regular expressions to extract data (example). For example this:

Please Login or Register  to view this content.

would extract

N:LastName;FirstName;MiddleName;Title;Suffix

You really need to provide real examples. For example an Outlook vcf file has Name like this:

BEGIN:VCARD
VERSION:2.1
N;LANGUAGE=en-us:Doe;John

These are real examples taken from 2 phones and their Myphone Explorer backup.
I just replaced the data with fake.

@mogul: I took a look at the page you suggested but I cannot understand much. Perhaps you can submit a work book with the relevant code.

I think most who tried to do this, they are starting out with a set column number, then try to sort into these the data from the vCard and at the end they ask if the user wishes to keep empty columns.

I also think that it is better that the column is created when reading the vCard data. At that point if the column label does not exist, create it, if it exists, place the data, if it exists and data is already placed while processing this record, create a second (when record has to numbers with the id "CELL" one number will go to column CELL and the other in CELL (2)).

Anyone?

@ Mogul: Sincere thanks for taking the time addressing this issue but I am unable to follow. (Cannot teach old dog (70) new tricks!).

I came accross the code in attached workbook which merely "transposes" the contents of the vCard from vertical to horizontal without separating the input in column header and data. (Just tename the .txt to .vcf, put the 2 files in the same folder and run the macro).

Could this be a starting point? Can a code use this to finally deliver what is expected?

Given the apparent difficulty of the task, let us make some compromises:

A. The data we are after is:
From the line starting with "N:" The title, first, middle and last name.
All lines that start with TEL.
And the lines starting with "ORG" and "TITLE".

B. The column header (Label) will be the entire respective vCard line before the last colon ":" Example "TEL;TYPE=CELL"
If an entry of the vCard has 2 or more of "TEL;TYPE=CELL", 2 or more columns with the same label will be created. (No need to make the 2nd "CELL (2)" etc.

The challenge will be to correctly put the data of each vCard record to the right column.

My only other suggestion is to import vfc files into Outlook and export a CSV file of contacts. All values will be in columns.