Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1042.Advanced search and replace -- How to convert csv or xls file to vcf file?

User: editor -- 2012-12-27          << 1041  1043 >>
Hits: 2496
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 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%)
How to convert csv files into tables with html format? (57%)

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