Table with row number, and comment as source of data - dat dividing

[globalmarek]

Hi, can anybody help my with build som table? I am not an expert but need to create some PDF document in Simulsoft software.
If some experts can support whould be glad

I have some date in schema
"invoiceline.invoiceline_comments" - example data in this field but can be more semicolons - "PO=YTY_2000022222| YTY_2000022224;PDDesc=Green box12|Blue box13;"

Need to convert:

Data for mapping

1.png (11.42 KiB) Viewed 353 times

PO - Customer PO
PDDesc - PD description
Docket - Docket no.
CustSpec - Customer Spec.
FSC - FSC Certificate no.
PCN - Custom Tariff No. (PCN)

This is what I need on PDF document:

2.png (11.46 KiB) Viewed 353 times

[Lech Kulikowski]

Hello,

Parsing a string and then displaying it directly on the bands in the report is a very complex task.
We recommend preparing the parsed data in the form of separate tables and then use it in the report.

Thank you.