Hi Scott, Yes that will work but I guess I'm missing something as I couldn't see which module I could use in a SPARQLMotion script to perform a SELECT query apart from an Iterate Over Select?
Regards, Mark. On Thursday, October 4, 2012 12:11:28 AM UTC+10, Scott Henninger wrote: > > 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
