Will SELECT DISTINCT ?substr work? If not, we will need more information on what your queries and script look like, etc.
-- Scott On Oct 2, 11:50 pm, Mark Colquhoun <[email protected]> wrote: > Hi, > > Within a SPARQLMotion script, I need to read a spreadsheet and find the > distinct values in a column based on a substring performed on the column. I > can do all of this except the distinct part and am looking for some > pointers. An example of the data might be: > > AI4120_0306_cH > AI4120_0306_cHH > AIC4120_0042_cSP > AIC4120_0042_sCV > > From these values, I want to create a substring including everything to the > left of the last _. > > AI4120_0306 > AI4120_0306 > AIC4120_0042 > AIC4120_0042 > > Easy enough so far but from here I want to select the distinct values. I'm > sure this should be easy but I haven't been able to find any build in > functionality to achieve this. The end result that am after should look > like: > > AI4120_0306 > AIC4120_0042 > > I'm sure there is something that I am overlooking so any help would be > greatly appreciated. > > Regards, > Mark. -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Ensemble, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en
