Hello. I would like to clean up my CSV file. I need to have all the columns separated instead of having all booking information in one line. I kind of figured out by researching and used the code below:
sep=;
'MAT_BOOKING_NUMBER';
'MAT_EVENT_TITLE';
'MAT_CSV_BOOKING_DETAILS'

I was able to separate the columns to First Name, Last Name, etc. However, I get two extra lines with the word "sep=" and the booking number. See attached image. How can I properly export to CSV without the word "sep=" showing up?

Also, I don't see information on an individual that was booked by someone else. He is bringing a guest but the guest information does not export. How do you export additional booking information? Does the CSV export only support information on who booked it?

I believe the participant list has all the guests but I need this file to be in CSV or Excel format.

Thank you for your help.

Best,
Eriko