Hi - I am trying to use a formula to flag a v string field when a name or number is not present. I am attaching the workflow and input to help answer this question. I've tried doing an IF statement with NULL, with EMPTY and with " " but none of those have worked. I can see the field is blank but can't figure out what statement will detect whatever type of blank this is. Can you help? It is the formula to detect blanks in the constituent name field or blanks in the constituent id field. Detecting "9-999999" works fine so I thought " " would. Thanks.
Could you upload an exported file? You can do this by going to Options -> Export Workflow
This should be a .yxzp file instead of the normal .yxmd
But in general, it wouldn't hurt to use the Data Cleansing Tool to remove unwanted characters. I would check 'Leading and Trailing Whitespace' and 'Tabs, Line Breaks, and Duplicate Whitespace' to remove these. Then perhaps one of the IF statements you tried previously will work.
Just to make sure I'm understanding you correctly-- were you trying to check for blanks in the constituent name? If so, you didn't have that 'Salutation' field checked in the data cleansing tool. I changed that and then one of your formulas downstream and see that now some go into 'no name'. Does that solve your problem? See the attached solution!