creating list (table) with part of a string

[rafael5958]

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 ?

[antoniotiman · Accepted solution]

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