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