Extract attendee names from .ics file

Help Robot
,
1

I need to get undefined number of attendee names (or emails if names don’t exist) from a .ics file I download and print them separated using semicolon (;).

Input:
ATTENDEE;CN="Name, Fake";RSVP=TRUE:mailto:fake.name@work.com
ATTENDEE;CN=“Boss, Fake”;RSVP=TRUE:mailto:fake.boss@work.c
om
ATTENDEE;CN=‘emailoutsideorganization@gmail.com’;RSVP=TRUE:emailoutsideorganization@gmail.co
m
ATTENDEE;CN=“Fake, Employeename”;ROLE=OPT-PARTICIPANT;RSVP=TRUE:mailto:
employeename.fake@work.com

Output:
Name, Fake;Boss, Fake;emailoutsideorganization@gmail.com;Fake, Employeename

2

Hi @mj.work

Check out the Regular expression

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=CN\W)\S.+(?="|”|’)").Tostring

image
image926×451 29.6 KB