On the other hand, I've managed to get a
reasonably complex parser written in it.
Taking a name - Osfameron.Adon@mycompany.com - it will split it into First, Mid, and Last names. Trivial? But our email address books have oddities like Dutch names having the prefix added to the first name - Wijnand-van-der.Valk@mycompany.com... And of course these prefixes should be part of the Middle name (to make alphabetising surnames less 'V' heavy...) whereas French prefixes shouldn't ("Le Brun")
With the various rules that we need to follow for this, it's a tricky but fundamentally doable task for Perl and Regular Expressions, but a horrible tarpit for VBA.
On topic?: Perl helped me write this application:
But no matter how you apply the Perlish way to VBA, it is not Perl... Some of the things I missed from Perl were:
(I don't think that
is the same)
On Error Goto
Programmers are always encouraged to learn other languages to get to grips with their features and constructs. I'm wondering whether I could recommend learning VB as a counter-example...?