Not sure what do yo want.
4 year digit of what?
Hi Shin, sorry DOB meaning Date of Birth.
There's this column called "Custom Field" containing strings like above and I need 1973 or 1982 extracted from each customer that has date of birth recorded.
Appreciate your quick reply! Works perfect.
Great to know Mid function works like that.
Hi Ossai, thanks for your quick feedback. I'm afraid regular expression aren't supported?? It didn't work seem to save correctly.. Maybe it did in the past version?
No worries. I got this figured out with Shin's advice.
You are welcome.