Truth, False, or Blank

[mo0926]

Hi everyone,

I was wondering how can I compare two files and check for matching records and flag each result accordingly with True, False, or Blank.

So for True or False I can easily use:

Code: Select all

self.fname_match := if(Le.fname = Ri.fname, 'T', 'F');

But how can I compare to get True, False or Blank when there is an empty string?

[rtaylor]

mauricexxvi ,

You could do it this way:

Code: Select all

self.fname_match := MAP(Le.fname = '' AND Ri.fname = '' => '',
                        Le.fname = Ri.fname => 'T',
                        'F');

So this code reads: IF the names are blank, return blank, ELSE IF the names match return 'T' ELSE return 'F'.

HTH,

Richard

[mo0926]

Thank you!