lookup to multi field index
scooter6 at gmail.com
scooter6 at gmail.com
Tue Aug 28 16:35:32 PDT 2018
Learn something every day - had no idea about the & to concatenate
there.....I've only ever used < or {
Never too old to learn
thanks Ken
S
On Tue, Aug 28, 2018 at 7:01 PM Ken Cole <ken.m.cole at gmail.com> wrote:
> Make sur the 2 variables are defined to match the field size and edit and
> concatenate together with an &, no space needed
>
> Ken
>
> On Wed, 29 Aug 2018 at 8:54 am, scooter6--- via Filepro-list <
> filepro-list at lists.celestial.com> wrote:
>
>> Having a big of a problem that I haven't encountered before
>>
>> I have output processing that has 2 variables that I set and then attempt
>> to lookup to a file on an index that has 2 fields
>>
>> za='value1';zb='value2';zc=za<ab
>>
>> lookup cli file k=zc i=T -nx
>>
>> I thought if you had a space between your values it would interpret that
>> as
>> the 2 fields you're using in your lookup?
>> The two fields in file are (25,*) and (6,*) respectively - the lookup I'm
>> doing, the first value za is only 13 characters long (this will vary
>> depending on which lookup I'm using, so I made the field length of 25
>> anticipating I won't have any values greater than 25) and the 2nd field
>> (zb) will always be length of 6
>>
>> What am I missing here?
>>
>> thanks
>>
>> Scott
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://mailman.celestial.com/pipermail/filepro-list/attachments/20180828/a55590c4/attachment.html
>> >
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180828/16c4a8cf/attachment.html>
More information about the Filepro-list
mailing list