[Tracker] Full Text Search and find word at offset fts:offsets

["Mildred Ki'Lya" <ml mildred593 gmail com>]

Hi,

There is the special function fts:offsets that return the offsets
where the query was found in a text property.

I was wondering, how can I later on take this offset and select an
extract to display where the text is found? I first thought that the
offset was a character offset and tried to split using that, but then
I noticed that didn't work. It's probably a word offset.

Do you know how I could split split the text into words. Is there a
known algorithm (regular expression?). Or is there a special SPARQL
function that can return the list of words in the text, with all
punctuation and non words removed?

Or better yet, is it possible to have an offset in bytes or characters ?

Thanks,

Mildred