I have to rename file(20000+) based on contents of file
(1)country---B!----at the end of title
(2)release--b3--short name at end of title in(enclosed in Parentheses)--***always not at the end of sentence
(3)Frequency---b6- Just adding abbreviation will do(D-daily, W-Weekly, M-Monthly, Q-Quarterly, S-Semi annually, A-Anually)
(4)seasonal adjustment---b5- Just adding abbreviation will do(NSA-Not Seasonally adjusted, SA)
(5)Time stamp-b9--only needed in DD-MM-YY, HH format-
(6)title-B1-title (excluding country name)
So format is
<Country>-<release>-<frequency>-<Season adjusted><time stamp><title>
Done so that even clear thing can be seen on smartphones.
Am attaching an example for reference
Zohar Batterywalaforum.ozgrid.com/index.php?attachment/69193/
Thread name-----File copying & renaming using VBA & WildCards
February 24th, 2012 #1 BY peter_345
Has tried this (with modification) but is not working