jlhfbo

PatternCount

Discussion created by jlhfbo on Oct 19, 2017
Latest reply on Oct 19, 2017 by jlhfbo

Hello All, I am successfully using PatternCount to find records that contain various characters when they occur in a word in a text field (i.e. F-R-Z or X) but need the same equation to (by selection of the user) to find EmptyFields.

 

I am using a Variable to the F-R-Z- or X. I tried setting the V arable to nothing or "" but it doesn't work?

 

$$WhatAsgn_B = ""

$$WhatAsgn_B =

 

This is the equation:

$$WhatAsgn_B = "F"

 

Fmp.B_Schedule::Name.B="" and

PatternCount ( Fmp.B_Schedule::Asgn.B; $$WhatAsgn_B)

 

Any thoughts would be appreciated....

 

-Jim

Outcomes