How do I remove the quotes and square brackets from the payment_gateway_names field?

The payment_gateway_names field is in JSON format by default and will look something like this:

["gift_card", "shopify_payments"]

In EZ Exporter, you can use the formula below in the Calculated Fields to remove the quotes and square brackets:

",".join(load_json_data({{ payment_gateway_names }}))

This will change the output to this instead:

gift_card,shopify_payments

App: EZ Exporter

Tags: advanced features, calculated fields