Return to FileMaker.com
Postcode Field Characters
i'm tryingto setup a field which picks up the initial postcode area but nothing else eg: BH, SO, GL so that i can run a report on number of customers in each area.
The problem occures with single letter postcodes such as E,W,S,B etc.
i have solved this once in the past but for the life of me i cannot remember how to do it although i think i used trim.
help appreciated as always
Filter ( Upper ( left ( PostCode ; 2 ) ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) I am sure there is a more elegant way to do this but it works.
I am sure there is a more elegant way to do this but it works.
Retrieving data ...