Hi guys,
I wonder if someone can help. I have a memo field contains demographic of a patient. The data is coming from a clinical application and all the data was clustered together into this memo field. I need to extract the post code out. The issue in England the post code could be 1 letter or 2
S26 1QB or WF1 6NG and so on. I have a table of the first part of the post codes WF1, WF2, S1, S20,DN20 etc...
Any idea appreciate it.
Thanks in advance
Wessam