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....