2 Replies Latest reply: Feb 8, 2018 4:19 PM by Marco Wedel RSS

    Multiple nested commands

    Jens Graunke

      Hi,

       

      I have a csv-table that looks roughly like this:

       

      IDExampleExample1Example2Example3Example4Example5Example6Example7Example8Example9
      1{'Example1':-5,'Example3':10}-510
      2{'Example2':-7,'Example5':15}-715
      3{Example1':10,'Example3':-2,'Example6':-11}10-211
      4{'Example1':-3,'Example2':-4,'Example3':15}-3-415
      5{'Example7':-28}-28
      6{'Example3':-1,'Example8':-2}-1-2

       

      I've tried:
      SubField((SubField((KeepChar(Example, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789+-:,')), ',')), ':', 1) as ExampleList

      to get following:

       

      ExampleList
      Example1
      Example2
      Example3
      Example4
      Example5
      ...

       

      Then when I click on "Example2" in that list, I want that all the rows are selected, that contain "Example2".

      But it's selecting rows, that aren't containing the selected...