[SOLVED] Split and rename single file into multiple files using keywords present in file

Issue

New to awk like commands. I have single text file holding SQL DDL's in below format.

DROP TABLE IF EXISTS $database.TABLE_A ;
...
...

DROP TABLE IF EXISTS $database.TABLE_B ;
...
...

Would like to split single file into multiple files as

1. TABLE_A.SQL
2. TABLE_B.SQL
3. TABLE_X.SQL

I am able to get the table names from single file with the help of below awk command. Still struggling to split and rename file with TABLE_X.SQL name.

awk 'FNR==1 {split($5,a,"."); print a[2]}' *.SQL

I am using Windows 10 DOS shell.

Solution

Finally I am able to acheive desired output with the help of below Shell script, which we can run in Windows bash shell ...

#!/bin/bash

#Split single file
awk '/DROP/{x="F"++i;}{print > x".TXT";}' $1

#Create output directory
mkdir -p ./_output

#Move file by chaning extention
for f in *.TXT ; do
  newfilename=$(awk 'FNR==1 {split($5,a,"."); print a[2]}' "$f")
  echo Processed $f ... new file is $newfilename".SQL" ...
       mv $f ./_output/$newfilename".SQL"      
done

Answered By - Aditya