Use search pattern to reformat the output

Shell Programming and Scripting
1

I have below file listing

] ls -1 *.txt
MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt
MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt
MISTradesReport_141107_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt
MISTradesReport_141108_d130240_VOLCKER_NA_BOND_FEED_2013-12-24.txt
MISTradesReport_141109_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-24.txt
MISTradesReport_141110_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-24.txt
MISTradesReport_141333_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-28.txt
MISTradesReport_141334_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-28.txt
MISTradesReport_141335_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-28.txt
MISTradesReport_141336_d130240_VOLCKER_NA_BOND_FEED_2013-12-28.txt
MISTradesReport_141337_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-28.txt
MISTradesReport_141338_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-28.txt
MISTradesReport_141362_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-29.txt
MISTradesReport_141363_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-29.txt
MISTradesReport_141364_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-29.txt
MISTradesReport_141365_d130240_VOLCKER_NA_BOND_FEED_2013-12-29.txt
MISTradesReport_141366_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-29.txt
MISTradesReport_141367_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-29.txt
MISTradesReport_141403_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141404_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141405_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt
MISTradesReport_141406_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
MISTradesReport_141407_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
MISTradesReport_141408_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt
MISTradesReport_141409_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141410_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141411_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt
MISTradesReport_141412_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
MISTradesReport_141413_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
MISTradesReport_141414_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt
MISTradesReport_141415_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141416_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
MISTradesReport_141417_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt
MISTradesReport_141418_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
MISTradesReport_141419_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
MISTradesReport_141420_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt

Need outout as

mv MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt
mv MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt
mv MISTradesReport_141107_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-24.txt
mv MISTradesReport_141108_d130240_VOLCKER_NA_BOND_FEED_2013-12-24.txt  VOLCKER_NA_BOND_FEED_2013-12-24.txt
mv MISTradesReport_141109_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-24.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-24.txt
mv MISTradesReport_141110_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-24.txt  VOLCKER_EMEA_BOND_FEED_2013-12-24.txt
mv MISTradesReport_141333_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-28.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-28.txt
mv MISTradesReport_141334_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-28.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-28.txt
mv MISTradesReport_141335_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-28.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-28.txt
mv MISTradesReport_141336_d130240_VOLCKER_NA_BOND_FEED_2013-12-28.txt  VOLCKER_NA_BOND_FEED_2013-12-28.txt
mv MISTradesReport_141337_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-28.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-28.txt
mv MISTradesReport_141338_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-28.txt  VOLCKER_EMEA_BOND_FEED_2013-12-28.txt
mv MISTradesReport_141362_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-29.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-29.txt
mv MISTradesReport_141363_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-29.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-29.txt
mv MISTradesReport_141364_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-29.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-29.txt
mv MISTradesReport_141365_d130240_VOLCKER_NA_BOND_FEED_2013-12-29.txt  VOLCKER_NA_BOND_FEED_2013-12-29.txt
mv MISTradesReport_141366_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-29.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-29.txt
mv MISTradesReport_141367_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-29.txt  VOLCKER_EMEA_BOND_FEED_2013-12-29.txt
mv MISTradesReport_141403_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141404_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141405_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt  VOLCKER_NA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141406_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
mv MISTradesReport_141407_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt  VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141408_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt
mv MISTradesReport_141409_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141410_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141411_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt  VOLCKER_NA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141412_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
mv MISTradesReport_141413_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt  VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141414_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt
mv MISTradesReport_141415_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_EMEA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141416_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-30.txt
mv MISTradesReport_141417_d130240_VOLCKER_NA_BOND_FEED_2013-12-30.txt  VOLCKER_NA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141418_d130240_VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt  VOLCKER_NA_CDS_CRDI_FEED_2013-12-30.txt
mv MISTradesReport_141419_d130240_VOLCKER_EMEA_BOND_FEED_2013-12-30.txt  VOLCKER_EMEA_BOND_FEED_2013-12-30.txt
mv MISTradesReport_141420_d130240_VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt VOLCKER_EMEA_CDS_CRDI_FEED_2013-12-30.txt

Tried below

ls -1 *.txt|sed 's/\(MISTradesReport_[0-9]*_d130240_\)\(\S*\)/mv \1\2.txt \2/g'

But couldnt get to the output yet

2

Hello,

The following script may help you.

##### For test I made 2 files at my system
#### took them in a file
 
$ ls *_2013-12-24.txt > OUTPUT_TXT
$ cat OUTPUT_TXT
MISTradesReport_141105_d130240_VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt
MISTradesReport_141106_d130240_VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt
 
 
 
#### Now we are chaging their name as per requirement
 
$ while read line
do
new_VALUE=`echo $line | sed 's/\(.*\)\(VOLCKER_.*\)/\2/g'`
mv $line $new_VALUE
done < "OUTPUT_TXT"
 
 
 
#### After execution of script we can check as follows.
$ ls *_2013-12-24.txt
VOLCKER_EMEA_LOANIQ_FEED_2013-12-24.txt  VOLCKER_NA_LOANIQ_FEED_2013-12-24.txt

NOTE: Script can be run as command without making a ksh or sh script too.

Thanks,
R. Singh

3

You may try using bash's parameter expansion feature

for i in *.txt;do 
    mv "$i" "${i/MISTradesReport_[0-9.]*_d130240_/}"
done
4

if you have Ruby

ls  MIST* | ruby -e 'ARGF.each{|x|x.chomp!;File.rename(x, x.split("_")[3..-1].join("_")  )  }'
5

There is a typo and a small correction to your code, try as:

ls -1 *.txt|sed 's/\(MISTradesReport_[0-9]*_d130240_\)\(V.*\)/mv \1\2 \2/'