Search Results

This is very convoluted logic. Using awk to read all of your 5000 files to get a list of files containing a certain string to use as arguments to another awk script is grossly inefficient since you...

Hello Vedanta,

Could you please try following and let me know if this helps you.

awk -F'[=/]' 'BEGIN{print "File | Jobname | node | pfile | metafile | tname |...

Hello Vedanta,

Could you please try following and let me know if this helps you.

awk -F'[ =/.]' 'BEGIN{print "Jobname...

No. grep prints matching lines or patterns - it does not rearrange nor combine lines. And it doesn't print headers.

Like so:
awk '
NR == 1 {print "Jobname \tType\ttype\tsqlname"
TYPE["d"] = "daily"
TYPE["w"] = "weekly"
next
}

...

$ x=a.txt.gz
$ echo .${x#*.}
.txt.gz

If you want uppercase for FILE_TYPE you may need to call tr eg:

echo FILE_TYPE=${Y%%_*} | tr -s '[:lower:]' '[:upper:]' >> $FN

first of all echo is not required in
for file in `echo $LIST_OF_FILES`just make sure you are in the same dir where the files are or use absoulte path and you can pass files to the loop as
for file...

$ sed "s/[^_]*_\([^_]*\).*/\1/" file
dat

meta

echo "xyz_dat_20110501_00000789.tar" | cut -d'_' -f2

Try:$ awk -F_ '{print $2}' file
dat

meta