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


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!