Convert VCF to CSV

NickNelsonCCIM

Hello, I have a 51mb VCF file with 18k contacts and I am trying to convert it to a CSV file.  I tried working with a LLM to build a workflow in Designer, but can't figure out how to do the regex stuff.  This is probably super easy for an Alteryx ninja who is used to dealing with the VCF format.

Any help would be greatly appreciated. Thank you!

Here is the format:

BEGIN:VCARD
VERSION:2.1
N:;Unknown;;;
FN:Unknown
EMAIL:bswaim@burns-commercial.com
NOTE;ENCODING=QUOTED-PRINTABLE:=49=44=3A=20=61=30=65=41=30=30=30=30=30=30=30=4B=53=54=4D=49=41=34=0A=
=50=72=6F=70=65=72=74=79=20=6E=61=6D=65=3A=20=4D=69=73=73=69=6F=6E=20=
=52=61=6E=63=68=0A=43=52=45=41=54=45=44=42=59=49=44=3A=20=30=30=35=41=
=30=30=30=30=30=30=31=65=77=4F=6E=49=41=49=0A=52=45=54=48=49=4E=4B=32=
=5F=5F=41=44=44=52=45=53=53=5F=4C=49=4E=45=5F=31=5F=5F=43=3A=20=35=36=
=30=30=20=42=61=62=63=6F=63=6B=20=52=64=2E=0A=52=45=54=48=49=4E=4B=32=
=5F=5F=42=55=49=4C=44=49=4E=47=5F=53=46=5F=5F=43=3A=20=30=0A=52=45=54=
=48=49=4E=4B=32=5F=5F=42=55=4C=4B=5F=5F=43=3A=20=46=41=4C=53=45=0A=52=
=45=54=48=49=4E=4B=32=5F=5F=43=45=49=4C=49=4E=47=5F=46=41=4E=53=5F=5F=
=43=3A=20=46=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=49=54=59=
=5F=5F=43=3A=20=53=61=6E=20=41=6E=74=6F=6E=69=6F=0A=52=45=54=48=49=4E=
=4B=32=5F=5F=55=4E=49=54=53=5F=5F=43=3A=20=32=39=36=0A=52=45=54=48=49=
=4E=4B=32=5F=5F=59=45=41=52=5F=42=55=49=4C=54=5F=5F=43=3A=20=32=30=30=
=31=0A=44=45=45=44=5F=44=41=54=45=5F=5F=43=3A=20=31=31=2F=31=2F=32=30=
=30=33=0A=4F=57=4E=45=52=5F=43=49=54=59=5F=5F=43=3A=20=42=6C=6F=6F=6D=
=69=6E=67=74=6F=6E=0A=4F=57=4E=45=52=5F=4E=41=4D=45=5F=5F=43=3A=20=53=
=20=26=20=48=20=52=65=61=6C=74=79=0A=4F=57=4E=45=52=5F=50=48=4F=4E=45=
=5F=5F=43=3A=20=28=39=35=32=29=38=38=34=2D=32=37=30=39=0A=4F=57=4E=45=
=52=5F=53=54=41=54=45=5F=5F=43=3A=20=4D=4E=0A=4F=57=4E=45=52=5F=5A=49=
=50=5F=43=4F=44=45=5F=5F=43=3A=20=35=35=34=33=31=0A=4F=57=4E=45=52=5F=
=43=4F=4E=54=41=43=54=5F=5F=43=3A=20=53=63=6F=74=74=20=45=6C=66=73=74=
=72=6F=6D=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=33=
=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=
=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=30=5F=44=41=59=53=5F=5F=43=3A=
=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=
=4E=5F=39=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=
=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=5F=4D=4F=4E=54=48=53=
=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=
=55=50=5F=49=4E=5F=31=5F=59=45=41=52=5F=5F=43=3A=20=46=41=4C=53=45=0A=
=41=4E=53=57=45=52=4E=45=54=5F=44=49=53=50=4F=5F=5F=43=3A=20=43=42=0A=
=43=4F=4E=54=41=43=54=45=44=5F=4F=57=4E=45=52=5F=5F=43=3A=20=46=41=4C=
=53=45
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;#DATA - Data Used;;;
FN:#DATA - Data Used
TEL;HOME:#3282
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;Unknown;;;
FN:Unknown
EMAIL:us9-bd6382f23e-5cc104b5f9@inbound.mailchimp.com
EMAIL:charles.klemmer@ets-lindgren.com
NOTE;ENCODING=QUOTED-PRINTABLE:=49=44=3A=20=61=30=65=41=30=30=30=30=30=30=30=4B=53=53=69=49=41=4F=0A=
=50=72=6F=70=65=72=74=79=20=6E=61=6D=65=3A=20=42=6C=61=6E=63=6F=20=43=
=72=6F=73=73=69=6E=67=0A=43=52=45=41=54=45=44=42=59=49=44=3A=20=30=30=
=35=41=30=30=30=30=30=30=31=65=77=4F=6E=49=41=49=0A=52=45=54=48=49=4E=
=4B=32=5F=5F=41=44=44=52=45=53=53=5F=4C=49=4E=45=5F=31=5F=5F=43=3A=20=
=31=33=39=39=39=20=4F=6C=64=20=42=6C=61=6E=63=6F=20=52=64=2E=0A=52=45=
=54=48=49=4E=4B=32=5F=5F=42=55=49=4C=44=49=4E=47=5F=53=46=5F=5F=43=3A=
=20=30=0A=52=45=54=48=49=4E=4B=32=5F=5F=42=55=4C=4B=5F=5F=43=3A=20=46=
=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=45=49=4C=49=4E=47=5F=
=46=41=4E=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=
=5F=5F=43=49=54=59=5F=5F=43=3A=20=53=61=6E=20=41=6E=74=6F=6E=69=6F=0A=
=52=45=54=48=49=4E=4B=32=5F=5F=55=4E=49=54=53=5F=5F=43=3A=20=33=32=34=
=0A=52=45=54=48=49=4E=4B=32=5F=5F=59=45=41=52=5F=42=55=49=4C=54=5F=5F=
=43=3A=20=31=39=39=36=0A=44=45=45=44=5F=44=41=54=45=5F=5F=43=3A=20=38=
=2F=31=2F=32=30=30=30=0A=43=41=4C=4C=5F=4E=4F=54=45=53=5F=5F=43=3A=31=
=53=54=20=43=41=4C=4C=20=4C=45=46=54=20=56=4D=20=37=2F=31=31=0A=4F=57=
=4E=45=52=5F=43=49=54=59=5F=5F=43=3A=20=53=61=6E=20=46=72=61=6E=63=69=
=73=63=6F=0A=4F=57=4E=45=52=5F=4E=41=4D=45=5F=5F=43=3A=20=46=75=72=6E=
=61=73=2C=20=4A=6F=68=6E=20=26=20=43=68=72=69=73=74=69=6E=65=0A=4F=57=
=4E=45=52=5F=50=48=4F=4E=45=5F=5F=43=3A=20=28=34=31=35=29=20=39=32=39=
=2D=37=36=32=39=0A=4F=57=4E=45=52=5F=53=54=41=54=45=5F=5F=43=3A=20=43=
=41=0A=4F=57=4E=45=52=5F=5A=49=50=5F=43=4F=44=45=5F=5F=43=3A=20=39=34=
=31=31=38=0A=4F=57=4E=45=52=5F=43=4F=4E=54=41=43=54=5F=5F=43=3A=20=52=
=79=61=6E=20=46=72=61=6E=63=69=73=63=6F=0A=4E=49=43=4B=5F=46=4F=4C=4C=
=4F=57=5F=55=50=5F=49=4E=5F=33=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=
=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=
=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=
=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=39=30=5F=44=41=59=53=5F=5F=43=3A=
=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=
=4E=5F=36=5F=4D=4F=4E=54=48=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=
=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=31=5F=59=45=41=52=5F=
=5F=43=3A=20=46=41=4C=53=45=0A=41=4E=53=57=45=52=4E=45=54=5F=44=49=53=
=50=4F=5F=5F=43=3A=20=56=4D=20=34=0A=43=4F=4E=54=41=43=54=45=44=5F=4F=
=57=4E=45=52=5F=5F=43=3A=20=46=41=4C=53=45
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;#BAL - Check Balance;;;
FN:#BAL - Check Balance
TEL;HOME:#225
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;Unknown;;;
FN:Unknown
EMAIL:brian_crowe@i-worx.com
NOTE;ENCODING=QUOTED-PRINTABLE:=49=44=3A=20=61=30=65=41=30=30=30=30=30=30=30=4B=53=54=50=49=41=34=0A=
=50=72=6F=70=65=72=74=79=20=6E=61=6D=65=3A=20=4B=65=79=73=74=6F=6E=65=
=20=61=74=20=41=6C=61=6D=6F=20=48=65=69=67=68=74=73=0A=43=52=45=41=54=
=45=44=42=59=49=44=3A=20=30=30=35=41=30=30=30=30=30=30=31=65=77=4F=6E=
=49=41=49=0A=52=45=54=48=49=4E=4B=32=5F=5F=41=44=44=52=45=53=53=5F=4C=
=49=4E=45=5F=31=5F=5F=43=3A=20=33=38=34=20=54=72=65=65=6C=69=6E=65=20=
=50=61=72=6B=0A=52=45=54=48=49=4E=4B=32=5F=5F=42=55=49=4C=44=49=4E=47=
=5F=53=46=5F=5F=43=3A=20=30=0A=52=45=54=48=49=4E=4B=32=5F=5F=42=55=4C=
=4B=5F=5F=43=3A=20=46=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=
=45=49=4C=49=4E=47=5F=46=41=4E=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=52=
=45=54=48=49=4E=4B=32=5F=5F=43=49=54=59=5F=5F=43=3A=20=53=61=6E=20=41=
=6E=74=6F=6E=69=6F=0A=52=45=54=48=49=4E=4B=32=5F=5F=55=4E=49=54=53=5F=
=5F=43=3A=20=32=32=34=0A=52=45=54=48=49=4E=4B=32=5F=5F=59=45=41=52=5F=
=42=55=49=4C=54=5F=5F=43=3A=20=31=39=39=34=0A=44=45=45=44=5F=44=41=54=
=45=5F=5F=43=3A=20=33=2F=33=30=2F=32=30=30=37=0A=43=41=4C=4C=5F=4E=4F=
=54=45=53=5F=5F=43=3A=20=31=53=54=20=43=41=4C=4C=20=4C=45=46=54=20=56=
=4D=20=37=2F=31=31=0A=4F=57=4E=45=52=5F=43=49=54=59=5F=5F=43=3A=20=4C=
=6F=73=20=41=6E=67=65=6C=65=73=0A=4F=57=4E=45=52=5F=4E=41=4D=45=5F=5F=
=43=3A=20=53=43=49=20=52=65=61=6C=20=45=73=74=61=74=65=20=49=6E=76=65=
=73=74=6D=65=6E=74=73=0A=4F=57=4E=45=52=5F=50=48=4F=4E=45=5F=5F=43=3A=
=20=28=33=31=30=29=20=34=37=30=2D=32=36=30=30=0A=4F=57=4E=45=52=5F=53=
=54=41=54=45=5F=5F=43=3A=20=43=41=0A=4F=57=4E=45=52=5F=5A=49=50=5F=43=
=4F=44=45=5F=5F=43=3A=20=39=30=30=32=35=0A=4F=57=4E=45=52=5F=43=4F=4E=
=54=41=43=54=5F=5F=43=3A=20=52=6F=62=65=72=74=20=4B=65=6C=6C=79=20=26=
=20=4D=69=6B=65=20=48=75=6E=74=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=
=55=50=5F=49=4E=5F=33=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=
=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=30=5F=44=
=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=
=4F=57=5F=55=50=5F=49=4E=5F=39=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=
=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=
=5F=4D=4F=4E=54=48=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=
=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=31=5F=59=45=41=52=5F=5F=43=3A=
=20=46=41=4C=53=45=0A=41=4E=53=57=45=52=4E=45=54=5F=44=49=53=50=4F=5F=
=5F=43=3A=20=56=4D=20=34=0A=43=4F=4E=54=41=43=54=45=44=5F=4F=57=4E=45=
=52=5F=5F=43=3A=20=46=41=4C=53=45
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:Stanley;Nancy;;;
FN:Nancy Stanley
EMAIL:nancystanleysold@gmail.com
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;Unknown;;;
FN:Unknown
EMAIL;PREF:brant.bright@es-cat.com
NOTE;ENCODING=QUOTED-PRINTABLE:=49=44=3A=20=61=30=65=41=30=30=30=30=30=30=30=4B=53=56=67=49=41=4F=0A=
=50=72=6F=70=65=72=74=79=20=6E=61=6D=65=3A=20=48=61=76=65=6E=20=45=61=
=73=74=0A=43=52=45=41=54=45=44=42=59=49=44=3A=20=30=30=35=41=30=30=30=
=30=30=30=31=65=77=4F=6E=49=41=49=0A=52=45=54=48=49=4E=4B=32=5F=5F=41=
=44=44=52=45=53=53=5F=4C=49=4E=45=5F=31=5F=5F=43=3A=20=38=30=30=31=20=
=47=65=73=73=6E=65=72=20=44=72=2E=0A=52=45=54=48=49=4E=4B=32=5F=5F=42=
=55=49=4C=44=49=4E=47=5F=53=46=5F=5F=43=3A=20=30=0A=52=45=54=48=49=4E=
=4B=32=5F=5F=42=55=4C=4B=5F=5F=43=3A=46=41=4C=53=45=0A=52=45=54=48=49=
=4E=4B=32=5F=5F=43=45=49=4C=49=4E=47=5F=46=41=4E=53=5F=5F=43=3A=20=46=
=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=49=54=59=5F=5F=43=3A=
=41=75=73=74=69=6E=0A=52=45=54=48=49=4E=4B=32=5F=5F=55=4E=49=54=53=5F=
=5F=43=3A=20=35=36=0A=52=45=54=48=49=4E=4B=32=5F=5F=59=45=41=52=5F=42=
=55=49=4C=54=5F=5F=43=3A=20=31=39=38=34=0A=44=45=45=44=5F=44=41=54=45=
=5F=5F=43=3A=20=36=2F=36=2F=31=39=39=31=0A=43=41=4C=4C=5F=4E=4F=54=45=
=53=5F=5F=43=3A=20=4E=4F=20=4D=45=53=53=41=47=45=20=4C=45=46=54=0A=4F=
=57=4E=45=52=5F=43=49=54=59=5F=5F=43=3A=20=53=61=6E=74=61=20=42=61=72=
=62=61=72=61=0A=4F=57=4E=45=52=5F=4E=41=4D=45=5F=5F=43=3A=20=42=6F=6F=
=74=68=2C=20=42=72=75=63=65=26=20=43=6F=6C=6C=65=65=6E=0A=4F=57=4E=45=
=52=5F=50=48=4F=4E=45=5F=5F=43=3A=20=28=38=30=35=29=20=39=36=39=2D=31=
=39=33=36=0A=4F=57=4E=45=52=5F=53=54=41=54=45=5F=5F=43=3A=43=41=0A=4F=
=57=4E=45=52=5F=5A=49=50=5F=43=4F=44=45=5F=5F=43=3A=20=39=33=31=30=38=
=0A=4F=57=4E=45=52=5F=43=4F=4E=54=41=43=54=5F=5F=43=3A=20=42=72=75=63=
=65=20=52=2E=20=42=6F=6F=74=68=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=
=55=50=5F=49=4E=5F=33=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=
=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=30=5F=44=
=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=
=4F=57=5F=55=50=5F=49=4E=5F=39=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=
=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=
=5F=4D=4F=4E=54=48=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=
=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=31=5F=59=45=41=52=5F=5F=43=3A=
=20=46=41=4C=53=45=0A=41=4E=53=57=45=52=4E=45=54=5F=44=49=53=50=4F=5F=
=5F=43=3A=20=56=4D=34=0A=43=4F=4E=54=41=43=54=45=44=5F=4F=57=4E=45=52=
=5F=5F=43=3A=20=46=41=4C=53=45
END:VCARD
BEGIN:VCARD
VERSION:2.1
N:;Unknown;;;
FN:Unknown
EMAIL:rrobin@concord-re.com
EMAIL:christian.villarreal@recar-realtors.com
NOTE;ENCODING=QUOTED-PRINTABLE:=49=44=3A=20=61=30=65=41=30=30=30=30=30=30=30=4B=53=61=36=49=41=47=0A=
=50=72=6F=70=65=72=74=79=20=6E=61=6D=65=3A=20=54=72=69=61=6E=67=6C=65=
=20=50=68=2E=20=49=0A=43=52=45=41=54=45=44=42=59=49=44=3A=20=30=30=35=
=41=30=30=30=30=30=30=31=65=77=4F=6E=49=41=49=0A=52=45=54=48=49=4E=4B=
=32=5F=5F=41=44=44=52=45=53=53=5F=4C=49=4E=45=5F=31=5F=5F=43=3A=20=34=
=36=30=30=20=47=75=61=64=61=6C=75=70=65=20=57=2E=0A=52=45=54=48=49=4E=
=4B=32=5F=5F=42=55=49=4C=44=49=4E=47=5F=53=46=5F=5F=43=3A=20=30=0A=52=
=45=54=48=49=4E=4B=32=5F=5F=42=55=4C=4B=5F=5F=43=3A=20=46=41=4C=53=45=
=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=45=49=4C=49=4E=47=5F=46=41=4E=53=
=5F=5F=43=3A=20=46=41=4C=53=45=0A=52=45=54=48=49=4E=4B=32=5F=5F=43=49=
=54=59=5F=5F=43=3A=20=41=75=73=74=69=6E=0A=52=45=54=48=49=4E=4B=32=5F=
=5F=55=4E=49=54=53=5F=5F=43=3A=20=33=33=35=0A=52=45=54=48=49=4E=4B=32=
=5F=5F=59=45=41=52=5F=42=55=49=4C=54=5F=5F=43=3A=20=32=30=30=35=0A=44=
=45=45=44=5F=44=41=54=45=5F=5F=43=3A=20=31=30=2F=31=32=2F=32=30=30=36=
=0A=43=41=4C=4C=5F=4E=4F=54=45=53=5F=5F=43=3A=20=50=48=4F=4E=45=20=4E=
=55=4D=42=45=52=20=49=53=20=4F=4E=20=54=48=45=20=44=4E=43=20=4C=49=53=
=54=2E=0A=4F=57=4E=45=52=5F=43=49=54=59=5F=5F=43=3A=20=4E=65=77=20=59=
=6F=72=6B=0A=4F=57=4E=45=52=5F=4E=41=4D=45=5F=5F=43=3A=20=4A=2E=50=2E=
=20=4D=6F=72=67=61=6E=20=49=6E=76=65=73=74=6D=65=6E=74=20=4D=6E=67=6D=
=74=2E=20=49=6E=63=2E=0A=4F=57=4E=45=52=5F=50=48=4F=4E=45=5F=5F=43=3A=
=28=32=31=32=29=20=34=38=33=2D=32=33=32=33=0A=4F=57=4E=45=52=5F=53=54=
=41=54=45=5F=5F=43=3A=20=4E=59=0A=4F=57=4E=45=52=5F=5A=49=50=5F=43=4F=
=44=45=5F=5F=43=3A=20=31=30=31=36=37=0A=4F=57=4E=45=52=5F=43=4F=4E=54=
=41=43=54=5F=5F=43=3A=20=43=68=72=69=73=74=69=6E=65=20=41=6B=69=6E=73=
=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=33=30=5F=44=
=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=
=4F=57=5F=55=50=5F=49=4E=5F=36=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=
=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=39=
=30=5F=44=41=59=53=5F=5F=43=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=
=4F=4C=4C=4F=57=5F=55=50=5F=49=4E=5F=36=5F=4D=4F=4E=54=48=53=5F=5F=43=
=3A=20=46=41=4C=53=45=0A=4E=49=43=4B=5F=46=4F=4C=4C=4F=57=5F=55=50=5F=
=49=4E=5F=31=5F=59=45=41=52=5F=5F=43=3A=20=46=41=4C=53=45=0A=41=4E=53=
=57=45=52=4E=45=54=5F=44=49=53=50=4F=5F=5F=43=3A=20=46=41=4C=53=45=0A=
=43=4F=4E=54=41=43=54=45=44=5F=4F=57=4E=45=52=5F=5F=43=3A=20=46=41=4C=
=53=45
END:VCARD

aatalai

@NickNelsonCCIM the easiest way I found was using the directory tool to pull in the files and then the ptyhon tool to read them 

from ayx import Alteryx
from ayx import Alteryx
import pandas as pd

# Read the input data containing file paths
input_df = Alteryx.read("#1")

# Get the file path from FullPath column
file_path = input_df['FullPath'].iloc[0]  # Get first file path

def read_vcf_file(vcf_path):
    """Read VCF file and return DataFrame"""
    try:
        # Read file and skip metadata lines starting with ##
        with open(vcf_path, 'r') as f:
            lines = [line for line in f if not line.startswith('##')]
        
        # Create DataFrame from remaining lines
        from io import StringIO
        df = pd.read_csv(
            StringIO(''.join(lines)),
            sep='\t',
            dtype={'#CHROM': str, 'POS': int, 'ID': str, 'REF': str, 'ALT': str},
            low_memory=False
        )
        
        # Rename #CHROM to CHROM for easier handling
        if '#CHROM' in df.columns:
            df = df.rename(columns={'#CHROM': 'CHROM'})
            
        return df
        
    except Exception as e:
        # Return error information
        return pd.DataFrame({'Error': [f"Failed to read {vcf_path}: {str(e)}"]})

# Read the VCF file
vcf_data = read_vcf_file(file_path)

# Add source file path to the data
vcf_data['SourceFile'] = file_path

# Output to Alteryx
Alteryx.write(vcf_data, 1)

VCF to CSV.zip