Contacts

Forget my suggestion.

It works but it requires a lot of time and a carefully match between data of CSV and Contacts.

Try the way of Csound1 and find a CSV VCARD converter.

Test it on a sample file.

paieyeagain wrote:

Csound, thank you, I have opened the MS Word table in the NeoOffice spreadsheet-module -- ought I to save it as an .xml file ? If I try to export it without first saving it, I am offered the same choices as are available in the word-processor.

Save As: comma seperated values (.csv)

Then download Open Office and use it.

Is this a .doc from MS Word? if it is then save as a .txt file (to strip formatting characters)

A CSF is nothing different than a TXT file.

Each line contains a Record (that is a "Card") where each of its fields are separated by a comma. Each line ends with a Reutourn and new line ASCI commands. (You may probably see the new line command as in word)

How do you have your records in your file ?

If you save them as TXT are they in lines with commas ?

If it is in this way just change the file name from .TXT to .CSV and it is done.

WALTER-MILANO-ITALY wrote:

If it is in this way just change the file name from .TXT to .CSV and it is done.

.TXT and .CSV should have different delimiters, but that can be adjusted for in the converter, good idea.

.txt may use spaces or periods, .csv uses comma's. However this is the ideal and deviation is common in the real world.

But ...

You said "I have opened the MS Word table in the NeoOffice spreadsheet-module"

Did you copy the table out of a Word doc and then try to use it, or is this the complete doc file.

As explained by Csound1. Delimiters is what separate the fields in the line. CSV=Comma Separated Values

You have to check what do you have in your TXT. May be commas spaces semicolon event tabs....

You can try to convert the file as it is after renaming into CSV and see what the converter does. Sometimes it will probably work with a delimiter different from comma.... need to test.

If necessary you can search and replace the delimiter.

The big problem may arise if you have same punctuation in your data, you imagine what happen if you have commas in your adress. You nead to make tests and after you have reached the decision which will be the delimiter that works with your converter before rearranging the file you will need to check for the presence of that delimiter and remove it.

I hope I am clear.

You see ... we go back to something similar to the complexity of my early suggestion.

Actually it is not complex, but you have to start with fresh mind and no noise around your table.

Merry Christmas 🙂

Thanks ans Merry Chrismas to you both.

It was a pleasure for me. First time I experience such a 3 side discussion 🙂

E un felice Natale a voi Walter