Skip to main content

I am trying to format this to readable text from my Jotform submission into my Shipday orders. I only want the highlighted product, amount, options to display as output. Any help would be appreciated! 

 

 

{product:oAnheuser-Busch Selection (Amount: 0.01 USD, Qty: 1, Select Beer Options: Stella Artois 6 Pack Bottles)],currency:USD,tax:0.00,shipping:0.00,subtotal:0.01,total:0.01,coupon:ORDERTEST,squareData:{transactionId:xQUWdq3ezexuvEjlHmRYXyCJfSLZY,amount:1,locationId:LVBRHWVBPCQK0,isCharged:true,currency:USD,submission_id:5770015757427076135}

Hi @tglasgow 

Good question.

One option is to use AI.

Action: ChatGPT - Extract Structured Data

NOTES:

  • Requires a ChatGPT Plus subscription
  • Requires an OpenAI billing payment method

Thanks! Any other possible solutions? 


@tglasgow 

You can write custom Code to parse and prep the data.