How to generate multiple dc:subject from one column?

[vlad...@sirma.bg]

I got two cols
?Keywords ?SupplementalCategories

with data like this
Black and white;Society;Monochrome;20th Century;Cinema;Screen;Actor;Uniform;Film director;Wartime;Home front;Cap;Ladders;Silent film;1910s , 10s;europeana photography;Europeana Food and Drink WWI;Film;Propaganda

How to generate multiple dc:subject by splitting them on ";" ?

The cols are optional. There may be optional spaces after ";"

With perl that's 2 lines...

[johna...@hotmail.com]

There is an open issue for this:

https://github.com/tarql/tarql/issues/46

Otherwise if you know upfront how many subvalues are in a value, you could use STRBEFORE() and STRAFTER() functions to extract the values.

SELECT ?s1 ?s2 ?s3

WHERE {

  BIND ("Black and white;Society;Monochrome" AS ?s)

  BIND (STRBEFORE(?s, ";") AS ?s1)

  BIND (STRAFTER(?s, ";") AS ?s_)

  BIND (STRBEFORE(?s_, ";") AS ?s2)

  BIND (STRAFTER(?s_, ";") AS ?s3)

}