AnsweredAssumed Answered

Export to vCard

Question asked by StefanSaeys on Nov 6, 2014

Title

Export to vCard

Post

 

I am trying to export my contact details to vCard format using following script:

Substitute(
If( IsEmpty(Contacts::Home Address 1); ""; Contacts::Home Address 1 &";")&
If( IsEmpty(Contacts::Home Address 2); ""; Contacts::Home Address 2 &";")&
If( IsEmpty(Contacts::Home City); ""; Contacts::Home City &";")&
If( IsEmpty(Contacts::Home State); ""; Contacts::Home State &";")&
If( IsEmpty(Contacts::Home Postal Code); ""; Contacts::Home Postal Code &";")&
If( IsEmpty(Contacts::Home Country); ""; Contacts::Home Country)
;"¶";"")

 

Everything seems to work except the country information. This results in

BEGIN:VCARD
VERSION:3.0
PRODID:-//Apple Inc.//Mac OS X 10.9.5//EN
N:Doe;John;;;
FN:John Doe
EMAIL;type=INTERNET;type=HOME;type=pref:john.doe@domain.com
TEL;type=HOME;type=VOICE;type=pref:199999999
TEL;type=WORK;type=VOICE:299999999
TEL;type=CELL;type=VOICE:498250744
ADR;type=HOME;type=pref:;;Church Road 23;Hemiksem;2620;Belgie;
NOTE:Notes
UID:6918bd7d-3859-414a-a5e0-41ddfdaf9f8c
X-ABUID:6918BD7D-3859-414A-A5E0-41DDFDAF9F8C:ABPerson
LN:Doe
END:VCARD 

and it should be:

ADR;type=HOME;type=pref:;;Church Road 23;Hemiksem;;2620;Belgie

Any help really appreciated; several attempts result in postcode being in the wrong field or country being in the postcode field.

Outcomes