Truth, False, or Blank
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:
But how can I compare to get True, False or Blank when there is an empty string?
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?
- mo0926
- Posts: 18
- Joined: Thu Jan 09, 2020 3:57 pm
mauricexxvi ,
You could do it this way:
So this code reads: IF the names are blank, return blank, ELSE IF the names match return 'T' ELSE return 'F'.
HTH,
Richard
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
- rtaylor
- Community Advisory Board Member
- Posts: 1619
- Joined: Wed Oct 26, 2011 7:40 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest