Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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