To filter certain data (desperately need help)

[lalakeyorai]

I’m using CR 2008 and i'm a new user of CR 2008. My question is, how can i filter data in order to make sure only data that have " IF-‘IP address’/ [se*/*/*] " is displayed in my report. regardless the number in the square bracket. As long as the data have
"[se / / ]", the data is needed. is there any relevent syntax that i can use? please advice me... Here’s the example of my data:

IF-10.10.1.33/143 [Mu1]
IF-10.10.1.2/112 [v/112]
IF-172.20.11.12/1 [se0/2/1]
IF-172.20.11.25/4 [se0/2/1]
IF-172.20.22.10/7 [se0/2/0]
IF-172.20.22.10/9 [se0/2/0]
FAN-173.20.21.10/1 [fan 1]
IF-173.20.135.10/4 [BR0/2/0]
IF-173.20.136.10/3 [se0/1/0]
IF-173.20.137.10/7 [se0/1/0]
IF-173.20.22.10/14 [BR2/0:1]
IF-173.20.24.10/5 [BR2/0:2]
IF-173.20.24.10/11 [se0/0/1]

those data was an example data so that you can get the idea of what im trying to do. there are almost 2000+ data in the actual database.

FYI, in my report those data are belong to one group called 'component name'. besides component name, there where also another columns of group.

 

[lbass]

Try a selection formula like this:

stringvar x := "";
if instr({table.string},"[se") > 0 then
x := mid({table.string},instr({table.string},"[se"));
stringvar array y := split(x,"/");
len(x) > 0 and
ubound = 3

-LB

 

[lalakeyorai]

LB, thank you very much for your respond and your formula. its relly help me a lot!!! so happy with that...

thank you so much