Finding a specifice value per the ranking sequence.

[Courtney Aspinwall]

What im looking for is Keyword = Milk, Juice and WTR were there is a P_Factor (ex P/1.000) and there is a continuation line below ( " ). Inmy example below the milk is missing the contiuation line. I created a Rank_Sequence Column based on the sequence. Per my Rank_Sequence and Keyword, 14 should be a ". How can identify that the "is missing from Jersey Cow

 

 

 

NAME

SEQUENCE

RANK_SEQUENCE

KEYWORD

EXPRESSION

P_FACTOR

 

 

JERSEY COW

110

11

CUMS

315.797 683.321 0.0 0.0 0.0 289.244

 

 

 

JERSEY COW

120

12

START

Feb-21

 

 

 

JERSEY COW

130

13

MILK

12.89396 X R/S 6.000000 EXP P/1.1000 23.757777

1.1

 

 

JERSEY COW

180

14

START

Feb-21

 

 

 

JERSEY COW

190

15

JUICE

1.1117 X l/D 6.000000 EXP P/1.5000 25.925749

1.5

 

 

JERSEY COW

200

16

"

Z 0.246430 l/D X YRS EXP 6.000000

 

 

 

JERSEY COW

220

17

START

Feb-21

 

 

 

JERSEY COW

240

18

WTR

0.98857 ZT/D 6.000000 EXP P/1.1000 22.328213

1.1

 

 

JERSEY COW

260

19

"

X 0.03046787 B/D Z YRS EXP 6.000000

[Gaia Paolini]

If the logic is: the row is invalid if there is a non-null P-Factor but the following line does not have Keyword='' then can you try this:

([P_FACTOR] is Null) or ((SN(Lead([KEYWORD],1)='"',True)=True) AND ([P_FACTOR] is not Null))

 

the '"' are a " surrounded by single quotes