REMOVE LINES

Question

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 Answer

@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] != "-------------"