Hi File Maker Pro Community,
I need help with a filtering issue. Below is the field I need filtered into a new field.
|Field 1||Field 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!