Wanted to replace string in an .xlsx file in multiple ZIP Files

UNIX for Advanced & Expert Users
1

Hi ,

I am having a ZIP file containing an .xlsx file . Now i wanted to replace "GJ" to blank in the .xlsx file .

I tried using the below code but not working , Please guide :

#!/bin/bash
log="/home/srikant/scripts/replacescriptFHO.log"
date > $log
echo "" >> $log
echo initiating for FHO >> $log
#dfolder="$(date +%d%m%Y --date='-1 day')"
dfolder="$(date +%d%m%Y)"


cd /fs/BHARTI_GUJARAT/TXN/FHO/
echo inside directory- `pwd` >> $log

newAddress=""
oldAddress="GJ"

for fname in file1.zip
do

  zipgrep -q $oldAddress $fname;  

echo hi 1 >> $log 
 
  if [ $? -eq 0 ]; then

echo hi 2 >> $log 

     filename="${fname%.*}" 

echo $filename >> $log

     unzip -qp $fname | sed -e 's#'$oldAddress'#'$newAddress'#g' FE_REPORT* 


     zip $filename.zip $filename
  fi
done

echo FHO done >> $log
echo ------------------------------------------------ >> $log
2

Your script wont work because a "*.xlsx" file isn't a text file but a (MS Excel) formatted text file...as such it cant be worked on by Linux/Unix utilities like sed etc...