Actually, there is a way to do this using the Regex functionality.
One thing that is a bit unclear to me is your column count.
In the sample it appears that the C is in column 8, not 7 (7 appears to be a space).
At any rate, here is one way to do it.
Using your before and after as an example
Capture the first 7 characters before the one you want copied into one group:
(\w{6} ) Note the space between } and )
the \w means any letter or number
now capture the letter you want to copy
(\w)This is group 2
Finally, capture The remainder of the filename
(.*)This is group 3
The end result is:
(\w{6} )(\w)(.*)Put this in the RegEx(1) Match box.
In the Replace box put:
\2\1\2\3This will give the result you are looking for.
To better understand, here's how it breaks down:
(I've used | to indicate the ends of chunks of text)
In the Match it gives the following groups
- Code: Select all
|YYYYMM | |C| |ustomerName Statement|
(\w{6} ) (\w) (.*)
Group \1 \2 \3
In Replace they are re-ordered
- Code: Select all
|C| |YYYYMM | |C| |ustermerName Statement|
Group \2 \1 \2 \3
Obviously, you can vary the number of characters in each block to suit your needs
Hope this helps,
Glenn