REMOVE LINES

[BRRLL99]

HI

I HAVE FOLLOWING DATA-SET

F12	F13	F14	F15	F16
AA>>1	BB22	10	20	33
550	100	20	30	22
83	100	30	40	44
-----------------	-----------------	-----------------	-----------------	-----------------
AA	DD	BB	CC	FF
-----------------	-----------------	-----------------	-----------------	-----------------
20	50	100	1	22
20	40	200	2	33
-----------------	-----------------	-----------------	-----------------	-----------------

target is remove "--------------" rows 

i have used multifield formula with [_CurrentField_] != "-------------"

i

[DataNath · Accepted solution]

@BRRLL99 are there ever instances where one cell will be ---------- and the other fields will be fine? If not and it always runs throughout every column, you could just filter on:

[F12] != "-------------"

If you need to check them all then it's not very glamorous but could just use:

[F12] != "-------------" AND

[F13] != "-------------" AND

[F14] != "-------------" AND

[F15] != "-------------" AND

[F16] != "-------------"