1 Reply Latest reply: Sep 5, 2017 11:08 AM by Antonio Mancini RSS

    creating list (table) with part of a string

    rafael scalabrin

      Hi, I have this situation....

      A cvs column with information like this.....

       

      M:\2016\aaaaa\vvvv\gggg\jjjjjj

      M:\2016\aaaaa\vvvv\gggg\jjjjjj

      M:\2015\bbb\vvvv\hhhh

      M:\2015\bbb\vvvv\hhhh

      F:\2016\HJFHSJK\DFDF\KJKJDKS

      F:\2016\HJFHSJK\DFDF\KJKJDKS

      F:\2016\HJFHSJK\DFDF\KJKJDKS

      F:\2016\HJFHSJK\DFDF\KJKJDKS

       

      What I want to do is to create 2 lists (or table if its easier to implement), one with the string till the 3rd "\" and one with the string between the 2nd and 3rd "\", something like

       

      list one:

      M:\2016\aaaaa\

      M:\2015\bbb\

      F:\2016\HJFHSJK\

       

      list two:

      aaaaa

      bbb

      HJFHSJK

       

      And in the table with the column populated from the cvs, i want to filter all searchs with the string in the list one. For example, if I click in "M:\2016\aaaaa\" in list one, it will filter:

      M:\2016\aaaaa\vvvv\gggg\jjjjjj

      M:\2016\aaaaa\vvvv\gggg\jjjjjj.

       

      Is it possible? how ?

        • Re: creating list (table) with part of a string
          Antonio Mancini

          Hi Rafael,

          maybe this

           

          LOAD TextField,Left(TextField,Index(TextField,'\',3)) as FieldA,
          SubField(TextField,'\',3) as FieldB Inline [
          TextField
          M:\2016\aaaaa\vvvv\gggg\jjjjjj
          M:\2016\aaaaa\vvvv\gggg\jjjjjj
          M:\2015\bbb\vvvv\hhhh
          M:\2015\bbb\vvvv\hhhh
          F:\2016\HJFHSJK\DFDF\KJKJDKS
          F:\2016\HJFHSJK\DFDF\KJKJDKS
          F:\2016\HJFHSJK\DFDF\KJKJDKS
          F:\2016\HJFHSJK\DFDF\KJKJDKS
          ]
          ;

          Regards,

          Antonio