Hello! I am collecting registration data through Eventzilla and trying to use Zapier to separate the registration answers that come in as a string of text into line items. Using a comma as a separator works fine until a registrant uses a comma within one of their registration answers (within an individual field). This inherently creates additional items within the output which throws things off. It is not an option to change the registration questions within Eventzilla to be multiple choice, dropdown, etc.-- it needs to be a text box.
I read through some of the articles and tried replacing the comma with a semi-colon via Formatter > Text > Replace yet that method replaces the commas within the registrant’s answers with semi-colons as well, not just the commas separating the answers.
Any help would be greatly appreciated! Thank you!