Hi
I have the following fields (FileName and FileSize) that I'd like to turn into the example table below. How can I remove the commas and the opening and closing square brackets from the field values?
FileName
-----------
[] <--- empty
[yellow.png, orange.jpg, green.gif]
[yellow.png, orange.jpg]
FileSize
-----------
[0]
[4321, 45678, 321]
[4321, 45678]
Table example
------------------------------------------------------
| FileName | FileSize | Count
------------------------------------------------------
| yellow.png | 4321 | 2
| orange.jpg | 45678 | 2
| green.gif | 321 | 1
Thanks in advance
... View more