Hello,

I'm trying to format the information I'm getting into a more readable format. In Etsy our products have two variations that come into Zapier as "Line Itemoptions Name" for the customer's options and "Line Itemoptions Value" for the customer's selection. Unfortunately, when the record is created in our database it comes in like this:

Finish,Distance

All Matte Black,9"

I'd like to be able to format it so that it looks more like this:

Finish: All Matte Black

Distance: 9"

However, when, for example, I try to separate the options using formatter it's treating it like two separate lines instead of one line with a comma. The output I'm getting from formatter looks like this:

0: Finish

1: Distance

But it's still writing "Finish,Distance" in our database.

As a result I cant use a comma to separate the two outputs as the fomatter seems to treat it as two separate lines but it always sends it out as one line with a comma.

Is there a way to get the output to be only one of the option names?

Thanks!