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
