PocketQuery template - handle comma delimited values in a column

Question

We have the following template working with a single value in the "Computers" column, such as "C01".

However, sometimes the Computers column contains more than one computer, such as:

* C01, C02

and we want each one converted to a separate link.  Some sort of a "for each" within the cell.

Any ideas on how to do this?

Michael Woffenden · Accepted Answer

Got it working. Note that we replace all commas with semi-colons prior to processing with PQ, hence the use of the semi-color in the below code. #foreach ($row in $result) #foreach ($key in $row.keySet()) #if ($key == "Computers") #set ($computers = $row.get("Computers")) #foreach($computer in $computers.split(";")) $computer #end #else $row.get($key) #end #end #end The Apache Velocity Engine - User Guide was very helpful.