Search Results

The print command appends a newline after a string and the printf doesn't.

Another approach:
awk -F\" 'BEGIN{print "Cust-Number,Cust-Name,Cust-Town,Cust-Purchase"}
/hobby/ || !NF{next}
/purchase/{print $2; next}
{printf $2 ","}
' file

If your grep doesn't support the -A and the -B options you can try:
awk 'NR==FNR{if($0 ~ /error/){n=NR}next}FNR > n-4 && FNR < n+4' /home/file.txt /home/file.txt

Try this:
awk 'NR % 6 {printf $0 FS; next}1' file

Use double quotes instead of single quotes to expand the shell variables:
sed -n "/$FromTime/,/$ToTime/p" $logFile > new_log.log

Please show what you have tried so far.

Thread closed, continue here:

https://www.unix.com/linux/255080-small-problem.html

With printf you can use the width trick, something like:
date | awk '{ printf("%s %*s\n", $2, 2, $3) }'

The sub function replaces only the field and preserves the field separators, $1="" or $1=x doesn't.

Try this:
awk -F\| 'NR==FNR{i=$1;sub($1,x); a[i]=$0; next} $1 in a{print $0 a[$1]}' input2.txt input1.txt

With awk:
awk '!p{p=sub("2Z694-00609",x)}1' file

I'm sorry, the first command should be:
newvar=$($var1 | awk '{print $1}')

Indeed :D

Sure.
df -h | awk 'NF==1{f=$1;getline;$0=f FS $0} int($5) >=80 {print "CRITICAL\n" $1 " has reach " $5}' file

Explanation:

NF==1{f=$1;getline;$0=f FS $0} -> if the line has 1 field add the...

Something like this?
ls -l 1*

This should be more efficient:
awk -F"[# ]" 'NR==FNR{a[$1]=$1;next}$NF in a {print $1, $2, a[$NF]}' list.txt testfile.txt

/^RC No/ - Matches the pattern at the beginning of the line
NF means the number of fields and $NF means the last field

Something like this?
awk '/RC No/{close(f);f=$4}{print >> f}' test.txt

Or maybe something like:
awk '/^TD/{close(f);f=$2}{print >> f}' file

Everyone at the UNIX and Linux Forums gives their best effort to reply to all questions in a timely manner. For this reason, posting questions with subjects like "Urgent!" or "Emergency" and...

awk '{$1=$1}1' RS= file

Try to run the sql string like this:
DoCmd.RunSQL SQL_NEW

The SQL string should be probably like:
SQL_NEW = "UDATE tblDataBuch SET Gedruckt = '" & CInt(blnVariable) & "' WHERE Gedruckt = 0;"
or
SQL_NEW = "UDATE tblDataBuch SET Gedruckt = " &...

Try this:
awk '$1=$1' RS= file

You can try something like:
awk '{for(i=1;i<=NF;i+=2)printf $i ":" $(i+1) FS}{print ""}' file