Hello All.
I have a email, whose output looks like this
[{"Item Name":"Item A ","Item ID":"9F6FE723","Date":"2021-09-03"},{"Workspace Name":"ItemB","Item ID":"B174AB0B","Date":"2021-08-27"}]
i need to format this, preferably into a table in the email
1. Item : Item A
Item ID : 9F6FE723
Date : 2021-09-03
2. Item : Item B
Item ID : B174AB0B
Date : 2021-08-27
There may be several more items, i am just using 2 as an example.
I tried to use the slit function, so whenever there is }, split the line into the next row - but for some reason, this add some funny characters to the text.
Can someone assist me please? Having the numbering would be beneficial.
Thanks
