Skip to main content

I’m using a Zap to pull data from registrations on Wild Apricot to a Google sheet. I want the field values for checklist questions to be delimited by pipes rather than commas. Is that possible? Here’s an example of the data that’s coming in:


Staying true to IASC roots: environmental commons in a changing world,Climate Change, Resilience, and the Commons,The Nonprofit Sector and the Commons,Knowledge Commons,Methodological Approaches and Computational Institutional Science,Indigenous commons,Commoning the Commons - Integrating Knowledge and Practice,Open call and emerging approaches

 

And here’s what I want it to look like (note that some of the field values have commas in them and those need to be preserved):

 

Staying true to IASC roots: environmental commons in a changing world|Climate Change, Resilience, and the Commons|The Nonprofit Sector and the Commons|Knowledge Commons|Methodological Approaches and Computational Institutional Science|Indigenous commons|Commoning the Commons - Integrating Knowledge and Practice|Open call and emerging approaches

Hi ​@Ben Roberts,

Welcome to the Community! 🎉

You can use Text in Formatter - Replace action to achieve this one. Here’s how it will look like:

cc4894294c6016c6a73bcd3cfe8a8204.png
(view larger)

 

c6f1b4bb06d3519d81096ce43da4c225.png
(view larger)

Hopefully, this helps.


Hi there, ​@Ben Roberts 👋

How did you get on with that Formatter (Text > Replace) action Ken suggested—did it do the trick?

Want to make sure you’re all set here so let us know on how you’re getting on!