Hi T, welcome.
tklein wrote:I need the following:
filenameone 01-01-08
filenametwo 01-02-08
filenamethree 01-03-08
to be:
filenameone 080101
filenametwo 080102
filenamethree 080103
Solution:
-- search for one-or-more of any char or sign ==> .+
------- group this for back reference ==> () ==> (.+) ==> filenamethree
-- then search for an blank
-- then for two digits and group them ==> (\d\d) ===> 01
-- then for an dash ==> -
-- then for two digits and group them ==> (\d\d) ===> 03
-- then for an dash ==> -
-- then for two digits and group them ==> (\d\d) ===> 08
On filenamethree 01-03-08 => "filenamethree" is hold in group "\1", "01" in group "2", "03" in "3" and "08" in "4"
Then simple do an new order in the replacement, first group \1, then group \4\2\3, or whatever you like.
RegEx(1)
Match: (.+) (\d\d)-(\d\d)-(\d\d)
Repl: \1 \4\2\3
HTH?
If yes, please help two others too.