It's locate instead locate fs 5e substr f2 /a/
For 'a' anywhere in field 2 On Thu, May 9, 2024, 12:11 Alain Benvéniste <a.benveni...@free.fr> wrote: > 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 >