Hi group, I'm moving a lot of legacy data to RDF these days and in several, mostly unrelated datasets I came across fields which had multiple values in it which should be split up into multiple entries. Imagine multiple names as an example.
This is quite common in SQL datasets which are not properly normalized, which seems to be more common than I thought :-) Fortunately such field often use separators so one could split that up pretty easily. I googled around if there is anything I can do with SPARQL (to avoid scripting) about this and found this posting: http://answers.semanticweb.com/questions/19162/split-and-trim-strings-in-sparql The most interesting answer is by Bob DuCharme, which showed how it is done in TopBraid: CONSTRUCT { :x :p ?member } WHERE { :x :p ?o . ?member spif:split (?o ",") } I found this a very useful function, is there anything like in in Jena? Couldn't find anything documented so far. regards Adrian
