1 Reply Latest reply: Mar 27, 2018 6:55 PM by David Forest RSS

    How do i filter or search variable possiblity

    Gerhard Lourens

      CSV data 1.JPG

       

       

      Good day..

      I have a Massive CSV file ( 120gb) from a database where the file is obviously no longer normalised.. I'm trying to build a filter or even just search a certain way.. if you look at the data.. there will be a . for option followed by a | for selection thereafter. now in those selections there can be a single number, or 2 3 4 5 how ever many the data gives..

       

      I want to be able to search or filter for instance ALL subsetinv.normal|"x,x,x" meaning all subsetinv normal with 3 number selections.

       

      how would one do that filter?