Search Results

Hello
I could not get few things in END.
like : c=(c=="")?i:c FS i and b=(b=="")?i:b FS i.
I know, ternary operator, but could not get this c=(c=="") and also what is the use of FS (field...

$ awk -vmin=100 '($3==0) && (min>$2) { min=$3;s=$1}END{ print s} ' file.txt

Hello Scrutinizer

in following sed command

Could you pls. explain what {p;q;} does.

thanks

Is AWK acceptable ?

Try This :

Hi Rocking77

temp.awk is input AWK script .

for example your input file name is file.txt then you can run program as follow

$ cat temp.awk
BEGIN{ }
{

if(NR>1)
{
if(NF==3 && NR==2)
{
printf("CREATE TABLE %s(%s %s",$1, $2, $3)
}

if(NF==3 && NR>2)
{
...

Could you pls. explain what does {p=1}p does in this code.

$ awk -F "|" 'NR==FNR{a[$3]=$0;next} $1 in a && NF==5{ print a[$1],"_",$3}' OFS="|" file1.txt file2.txt
2|_|W|_||_|A
4|_|Z|_||_|C