Search Results

awk 'NR==FNR{a[$1]=$2;next}
{for(i=1;i<=NF;i++) if($i in a) print a[$i] FS $0}' pattern report
4 i like very much
2 but john is good boy
3 i will love u

awk 'FNR==NR && FNR>1{a[$1]=$2} NR>FNR{ for(i=1;i<=NF;i++) if($i in a) $i=a[$i]$i; print $0}' pattern.txt chennai.dat

last=$(ls *.CLT| cut -c7-10| sort -n |tail -1)
new=$(printf "%04d" $((10#${last}+1))) #determine the next consecutive number.
cat *.CLT > $(date +%y%m%d)$new.CLT

or without using cut...

newfile=`ls *.CLT |awk -v today=$(date +%y%m%d) '{max=(substr($0,7,10)>max)?substr($0,7,10):max}END{printf "%6s%04d.CLT",today,max+1}'`
cat *.CLT > $newfile

Ok, if the understand is right.

Last=$(ls *.CLT|sort -n |tail -1)
let new=${Last%.*}+1 #determine the next consecutive number.
cat *.CLT > $new.CLT

ls wrk/*.R | awk '
{
sub("^wrk/", "");
sub(".R$", "");
pre=post=$0;
sub("[0-9]*$", "", pre);
sub("^[A-Z]*", "", post);
new=sprintf("%04d", ++P[pre]);
if (new !=...

How about this, should work in bash or ksh

MAX=0
for file in wrk/[0-9]*.CLT
do
CNT=${file##wrk/}
CNT=${CNT%%.CLT}
[ $CNT -gt $MAX ] && MAX=$CNT
LIST="$LIST $file"
done...

Please try:

awk -v RS="%s" 'NR==FNR && NR!=1{a[$1]=a[$1]"%s"$0}END{for(i in a) print "%s"a[i] >"MUMBAI000"++x".txt"}' urfile

Well, consider the merge to be another task, rather than cluttering the process that works. The only thing you might need is keys, which might go into the file name. Then, you can process the file...

If the blank line between CREATE TABLE paragraphs is always present this should suffice:

awk '/CREATE TABLE/{ n++; print > (f="out_" n); close(f)}' RS= sql_file

Otherwise use,

awk...