csv转vCard格式，用于通讯录批量导入手机。
csv字段如下：
|
1 2 |
[root@repo csv2vcf]# cat list.csv 姓,名,QQ,手机号,邮箱,职位,生日,公司,部门 |
csv2vcf.sh代码：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
#!/bin/bash ############################ # Usage: # File Name: csv2vcf.sh # Author: annhe # Mail: i@annhe.net # Created Time: 2015-09-10 11:32:50 ############################ while read id;do FIRSTNAME=`echo $id | awk -F "," '{print $1}'` LASTNAME=`echo $id | awk -F "," '{print $2}'` CORP=`echo $id | awk -F "," '{print $8}'` DEPART=`echo $id | awk -F "," '{print $9}'` TITLE=`echo $id | awk -F "," '{print $6}'` TEL=`echo $id | awk -F "," '{print $4}'` EMAIL=`echo $id | awk -F "," '{print $5}'` IMADDRESS=`echo $id | awk -F "," '{print $3}'` cat >> list.vcf <<EOF BEGIN:VCARD VERSION:2.1 N;LANGUAGE=zh-cn;CHARSET=utf8:$FIRSTNAME;$LASTNAME FN;CHARSET=utf8:$FIRSTNAME$LASTNAME ORG;CHARSET=utf8:$CORP;$DEPART TITLE;CHARSET=utf8:$TITLE TEL;CELL;VOICE:$TEL X-MS-OL-DEFAULT-POSTAL-ADDRESS:0 EMAIL;PREF;INTERNET:$EMAIL X-QQ:$IMADDRESS END:VCARD EOF done <list.csv |
发表回复