Mon Jan 24, 2022 5:58 am
Login Register Lost Password? Contact Us

Truth, False, or Blank

Questions around writing code and queries

Tue Feb 18, 2020 4:53 pm Change Time Zone

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?
Posts: 18
Joined: Thu Jan 09, 2020 3:57 pm

Tue Feb 18, 2020 5:02 pm Change Time Zone

mauricexxvi ,

You could do it this way:
Code: Select all
self.fname_match := MAP(Le.fname = '' AND Ri.fname = '' => '',
                        Le.fname = Ri.fname => 'T',

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


Community Advisory Board Member
Community Advisory Board Member
Posts: 1611
Joined: Wed Oct 26, 2011 7:40 pm

Mon Sep 21, 2020 8:46 pm Change Time Zone

Thank you!
Posts: 18
Joined: Thu Jan 09, 2020 3:57 pm

Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest