Hi,
I would like to select records where the target is found in a field.
So I thought to use PICK.
Input file is :
a;a;a;a;a;zaz;a;a;a;a
The pipe :
"PIPE < A A A",
"! PICK FIELDSEparator 5E /a/ IN Fields6.1",
"! CONSole"
The error :
FPLPIC687E Relational operator expected; found ields6.1
FPLMSG003I ... Issued from stage 2 of pipeline 1
FPLMSG001I ... Running "PICK FIELDSEparator 5E /a/ IN Fields6.1"
The doc says :
IN Match when all characters of the first operand are present in the
second one or the first operand is null.
I would like to test if a is somewhere in field6, not the contrary.
It looks like that we can't code Fields on the right side.
Alain
