#!/bin/bash
# copying MCE Repricing ASPRODUCTSUMMARY
cd /u02/sppdw/dw/infa_shared/SrcFiles/POPS;
for files in $(ls *.MCESOLUTION);do $(cp -v $files 'UNPROCESSED/ASPRODUCTSUMMARY/'${files%.MCESOLUTION}.CSV); done;
exit 0;

#!/bin/bash
# MCE Repricing ASPRODUCTSUMMARY ONLY DATA
cd /u02/sppdw/dw/infa_shared/SrcFiles/POPS/UNPROCESSED/ASPRODUCTSUMMARY;
####ls -1 /u02/sppdw/dw/infa_shared/SrcFiles/POPS/UNPROCESSED/ASPRODUCTSUMMARY > ListofMCECSVFilesASPRODUCTSUMMARY.txt
FOLDERDIR='/u02/sppdw/dw/infa_shared/SrcFiles/POPS/UNPROCESSED/ASPRODUCTSUMMARY';
cd $FOLDERDIR;
for i in $(ls -l | grep '^-' | awk '{print $9}')
do  
$(grep -i "^..............ASPRODUCTSUMMARY"< "$i" > newfile);
$(mv -v "newfile" "$i"); done;
exit 0;

for

#!/bin/bash
#!/bin/bash
# MCE Repricing ASPRODUCTSUMMARY Append Casid n studytype in each line
FOLDERDIR='/u02/sppdw/dw/infa_shared/SrcFiles/POPS/UNPROCESSED/ASPRODUCTSUMMARY';
cd $FOLDERDIR;
for f in $(ls *.CSV); do caseid="$(echo "$f" | cut -c1-10)";
studytype="$(echo "$f" | cut -c12-15)";
prefix="$caseid,$studytype,";
echo $prefix;
while read line 
do echo "${prefix}$line" done < "$f" > "newtempfile";
mv -v "newtempfile" "$f";
done;
exit 0;

#!/bin/bash
# MCE Repricing ASPRODUCTSUMMARY Append Casid n studytype in each line
FOLDERDIR='/u02/sppdw/dw/infa_shared/SrcFiles/POPS/UNPROCESSED/ASPRODUCTSUMMARY';
cd $FOLDERDIR;
for f in $(ls *.CSV); do caseid="$(echo "$f" | cut -c1-10)"
studytype="$(echo "$f" | cut -c12-15),"
prefix="${caseid//[[:space:]]/},${studytype//[[:space:]]/}";
while read line; do echo -n "${prefix}$line" ;done< "$f" > newtempfile;
$(mv -v "newtempfile" "$f");
done;
exit 0;

//[[:space:]]/