Split a row with data separated by ","

Question

I need to split a row from a DE. The row contents 4 strings, and I want to see the content in a table. Right now I have some code; but doesn't work:

Script

%%[
VAR @Productos<br/>

SET @Productos = AttributeValue('Productos') <br/>
SET @item = TreatAsContent('{{item}}')<br/>
SET @sku = TreatAsContent('{{sku}}')<br/>
SET @qty = TreatAsContent('{{qty}}')<br/>
SET @price = TreatAsContent('{{price}}')<br/>
<br/> ]%%

Inside html:

Product: %%=V(@item)=%% <br/>
SKU:  %%=V(@sku)=%% <br/>
Quantity: %%=V(@qty)=%% unidades <br/>
Price:   %%=V(@price)=%% <br/>

Some images of the error and the code of the "Confirmation Email"

The CODE of the EMAIL-CONFIRMATION.html

Answer 1

Guide Template Language does this effortlessly. No need for SSJS, or awkward AMPscript process loops. The following code:

%%[
var @products
set @products = '[{"item":"Elastic love","sku ":"PUL1288MTL0000M","qty":1,"price":69.00},{"item":"Seashore","sku ":"PEN0576MCLMTL0U","qty":1,"price":59.00}]'
]%%

<table border="1">
  <tr>
    <th>Item</th>
    <th>SKU</th>
    <th>Quantity</th>
    <th>Price</th>
  </tr>

{{.datasource products type=variable source=@products}}
   {{.data}}
      {"target":"@products"}
   {{/data}}

  <tr>
    <td>{{item}}</td>
    <td>{{sku }}</td>
    <td>{{qty}}</td>
    <td>{{price}}</td>
  </tr>

{{/datasource}}

</table>

Will produce the following output:

All you need to do is change my set @products statement to use set @products = AttributeValue('Productos')