AnsweredAssumed Answered

Filtering Data

Question asked by BlancheMcdade on Jul 18, 2017
Latest reply on Jul 19, 2017 by BlancheMcdade

Hi File Maker Pro Community,

 

I need help with a filtering issue.  Below is the field I need filtered into a new field.

Field 1Field 2 Filtered Results
AMA|P|0|RA|0AMA
CAACH|NP|0|M|0CAACH
GAAM|P|0|NBA|60GAAM

 

Field 1 data could have from 3 to 6 letters.

In Excel, I can  do this by simply using Text to Column, output Delimited and selecting as the starting point |  ).

How can I do this in File Maker Pro 16?

I have tried using Filter (texttoFilter;filterTex) and FilterValues ( textToFilter ; filterValues )

Thanks ,help is appreciated!

Blanche

Outcomes