Null, empty, blank or ???? fields

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.

NTFB BBCRM Appeal Upload file.yxmd

field check1911CM01.csv

Expression

Accepted answers

mmenth

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!

NTFB BBCRM Appeal Upload file.yxzp

All comments

mmenth

Hi mgrau,

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.

Best,

Megan

mgrau

I tried all three choices after adding the Data cleansing tool to the input without any luck. So I must be missing something. Here's the exported workflow.

NTFB BBCRM Appeal Upload file.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703