| User: editor -- 2012-12-27 << 1041 1043 >> |
| Hits: 4457 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to convert csv or xls file to vcf file? The csv file contain 2 columns: name and telephone, convert it to vcf files, so I can import into mobile phone. |
| Input Sample: |
| name1,0123456789 name2,0123443210 ... |
| Output Sample: |
| BEGIN:VCARD VERSION:2.1 N:;name1 FN:name1 TEL;WORK;VOICE:0123456789 REV:20100606T103709Z END:VCARD BEGIN:VCARD VERSION:2.1 N:;name2 FN:name2 TEL;WORK;VOICE:0123443210 REV:20100606T103709Z END:VCARD ... |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. Save the xls into csv file with following format: name1,0123456789 name2,0123443210 2. ctrl-o open the csv file 3. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Line' * set 'replace with pattern' to: 4. click 'replace', done. 5. select "settings->Encoding" menu, set encoding to "utf-8" 6. ctrl-s save the result to my_contact.vcf, done! Note: You can ignore step 5 if you mobile phone support your default encoding type. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to batch convert word docx files to txt files? (68%) How to convert a text file to specified format? (64%) How to convert many html files to text files all at once? (60%) How to convert each line of a text file to the new format? (59%) How to merge odd lines from file1 and even lines from file2? (58%) How to convert the text from decimal to hex in a file? (58%) How to convert the text from hex to decimal in a file? (58%) How to convert the data into a table with columns? (58%) |
Check Demo of Advanced search and replace |
| Keywords: |
| 0123443210 xls 101 606 321 contact telephone 123456 vcard vcf search replace support encoding convert csv to xls convert vcf to csv xls xls to vcf convert xls to vcf file xls to csv vcf files to csv files convert csv to vcf |