SELECT DISTINCT ?sa ?oa FROM <http://ucb.com/nbeabase> WHERE { ?sa a <http://ucb.com/nbeabase/resource/Batch> . ?sa <http://ucb.com/nbeabase/resource/chemAbsNo> ?oa . FILTER regex(?oa, '-','i') }
You can use the following SPARUL pattern to harmonize the property values across relevant triples in a specific graph, as shown below:
SQL> SPARQL INSERT INTO GRAPH <http://ucb.com/nbeabase> { ?sa <http://ucb.com/nbeabase/resource/sampleId> `str (?oa)` } WHERE { ?sa <http://ucb.com/nbeabase/resource/chemAbsNo> ?oa . FILTER regex(?oa, '-','i') }