Help with co
Richard D. Williams
richard at appgrp.net
Mon Jul 2 12:43:59 PDT 2018
When using the "co" or contains, it is most important to make sure there
are no trailing blanks spaces.
If the real field is 20 chars. and the last name is "Williams", there
are 12 trailing spaces that will make your statement false in this case;
assuming field 4 is the last name 20 chars in length with a value of
"Williams"
name(3) is "Richard D. Williams"
if: not(name(3) co 4)
This would be true. Saying that name(3) _does not_ contain "Williams".
But it does.
Now, if you take the last name real field 4 in our example and place it
inside "l", like this; l=""{4{"",
you eliminate the trailing blanks space contained in the real field and
the statement above would be false.
Possibly it would be easier to show the opposite case, but I hope you
get my drift here.
Hope this helps,
Richard
On 7/2/2018 2:02 PM, Jose Lerebours via Filepro-list wrote:
> This is simple:
>
> (1) do lookup
>
> (2) use a label like CKLast AS
>
> CKLast:if:name(3) co "LastName"
>
> :then:
>
> Next line you will check if the CKLast was true or false ...
>
> :if:not CKLast
>
> :then: ... last name string not in name(3) process goes here ...
>
>
>
>
> On 07/02/2018 01:35 PM, Richard Kreiss via Filepro-list wrote:
>> I am creating an output process which checks if a last name field
>> contains(co) the name in a lookup file.
>>
>> If: name(3) not co Lastname
>>
>> The issue I am having is how to do a not contain (not co) yields a
>> syntax error.
>>
>> The file being used might have a suffix such as Jr or Sr or II. I am
>> trying to avoid having to eliminate these suffixes. If I need to do
>> this, it will just complicate this processing.
>>
>>
>> Richard Kreiss
>> GCC Consulting
>>
>>
>>
>>
>>
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: winmail.dat
>> Type: application/ms-tnef
>> Size: 13897 bytes
>> Desc: not available
>> URL:
>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180702/781137d6/attachment.bin>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
>
>
> ---
> This email has been checked for viruses by AVG.
> https://www.avg.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180702/24a8cb02/attachment.html>
More information about the Filepro-list
mailing list