Forum Discussion

deefunk1981's avatar
deefunk1981
Frequent Visitor
4 years ago
Solved

Extract first 4 digits from postcode from text column

Hi,   I have a column which has full addresses in it which due to the various ways the addresses have been handed over from the client I can't use the extract by delimiter function.  I would like t...
Need Help
deefunk1981's avatar
deefunk1981
Frequent Visitor
4 years ago

Thank you so much for all your help everyone.  The solution is now working 😁

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Do all the postal codes include "BT"?

    • deefunk1981's avatar
      deefunk1981
      Frequent Visitor
      4 years ago

      Yes, all the postcodes are Northern Ireland and thankfully all start with BT which makes things a lot easier.