How to construct query to change all the values of properties in a triple to strings?
Suppose for given graph all values of properties are a mixture of strings and decimals.
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') }
In order to change the values to string, should be executed the following statement:
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') }