Skip to main content

I have a form submission trigger step that includes various custom field data into a comma-delimited text string. 

See the attached image “output from trigger” - specifically the fields Custom Fields Value, and Custom Fields Name. As you can see there are about 12 custom fields. 

I’m trying to extract the data from just one of those custom fields, Coupon Code. I thought I could just create a Formatter step with Utilities > Line Itemizer, however when I try to do that, all of the empty values and commas in Custom Fields Value are removed. See attached image “input to formatter”. So the Line Itemizer is unable to correctly match up custom field names and values, as it now thinks there are just 5 values in “Custom Fields Values”. 

It seems that these commas are being removed somewhere between the output from the trigger step, and the input to the formatter step. How can I make this work? 

Thank you in advance!! 

Rick 

Hi ​@ivytutors 

Follow this related guide:

 


Thank you Troy! That was the ticket, it worked. 


Yay! 🎉 Really pleased to see Troy was able to help point you in the right direction here, ​@ivytutors! Big thank you to ​@Troy Tessalone for writing that helpful guide and for sharing it here! 🤗

Seems like you’re all set for now ​@ivytutors but please do reach back out to the Community if you need any help in future—we’ll always be happy to help! 


Reply