A collection of especially useful xplorer² topics and ideas. New users may find it helpful to look here before searching the other forums for information. >>>>>> Please post new material in the relevant forum. (New stuff posted here will be removed.) Thanks. -fg-
nikos wrote: i'd sooner write a full VBS script to do what i want
Does this mean a version of x2 that supports OOP and VBA may be in the future?
Sorry, been getting dizzy lately learning to use VBA for Excel - wonderful programming environment. Using worksheets like dataspaces, and the similarities to APL (IBM's A Programming Language) workspaces is "enticing".
OK, back to the topic, and BTW, you RE gurus are awesome!
But having another look at that might have a benefit for me anyway already. It seems that there is at least a pattern that the last 4 numbers always indicate month and day and only the year is split sometimes in parts. So it might be possible to work with an expression that keeps the last four digits and replaces the other numbers before it with the year like "-2006".
So I might not need the pairs anymore. What's the string for this?
(The pair solution would then still be an intellectual challenge )