fixMultiDate.rq

PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rico: <https://www.ica.org/standards/RiC/ontology#>
PREFIX stabs-d: <stabs:scope:data/>

WITH <https://ld.staatsarchiv.bs.ch/graph/source>

# Update query to fix multiple date values (take only first)
DELETE {?s rico:expressedDate ?o}
INSERT {?s rico:expressedDate ?1Date}
WHERE { 
  ?s rico:expressedDate ?o .
  FILTER REGEX(?o, '\r\n\r\n')
  BIND (STRBEFORE(?o, '\r\n\r\n') AS ?1Date)
}