How do i do count({< field=P(field2)>}ID)

[D19PAL]

Hi,

How do i do the following in the script?

 count({< field=P(field2)>}ID)

+

 count({< field2=P(field)>}ID)

To see if field1 is in field and if field is in field1.

Data

ID,field,field1,

1,NN,CJ

2,NN,CJ

3,CJ,PT

4,DP,TF

So result will be 3, ID 1,2,3 because they feature in both columns

Thanks