Search Results

Show us your attempts!

---------- Post updated at 15:41 ---------- Previous update was at 15:36 ----------

Howsoever, tryawk '/Estimate|realized/ {printf "%s%s ", $1, FS} /USD|Date:/' FS=":"...

Try awk '
NR==FNR {a[$0]
next
}
{for (i in a) {m=split (i, b, " ")
for (j=1; ($0 ~ b[j]) && j<=m;...

awk -F"[a-z=&\"]*" '{print $2,$3,$4}' infile
70 15481 6991901
7078 15482 70121
709 15484 70183944

@Yoda
I get this with your solution
70 15481 6991901
7078 15482 70121 é
709 15484 70183944

Here is an awk approach:
awk '{gsub(/[[:punct:]]+|[[:alpha:]]+/," ");sub(/^[ ]*/,x);NF-=2}1' file

here is corrected one

awk -v p="1-2,4-13,16,19-20,21-25,31-32" -v dn="file.pdf" 'BEGIN{ORS=" ";n=split(p,t,",");for (i=1;i<=n;i++) if(t[i] ~ /-/) {split(t[i],t1,"-"); print "-dFirstPage=" t1[1]...

Hi

awk -v p="1-2,4-13,16,19-20,21-25,31-32" -v dn="file.pdf" 'BEGIN{ORS=" "; x=split(p,t,",");for (i=1;i<=x;i++) if(t[i] ~ /-/) {split(t[i],t1,"-"); print "-dFirstPage=" t1[1] ,"-dLastPage="...

$ cat fmrg.awk

!F { F=FILENAME; FILENUM=1 }
F != FILENAME { FILENUM++; F=FILENAME }

{
if((!MIN) ||(MIN>$1)) MIN=$1
if((!MAX) ||(MAX<$1)) MAX=$1
R[$1]++;...

The test is pointless, just remove it:
'{nr[$1]=$2;f = $1} END{for (i=1;i<=f;i++) print i, nr[i] }'

awk '{ for(N=1; N<=NF; N+=2) print $N, $(N+1); }' filename > outfile

Try this...
awk 'NR==FNR{a[$0]++;next}{for(i in a){gsub(i,"",$0);gsub("[,.] *$","")}}1' patternlist infile
--ahamed

Sorry, just caught me on a bad day I suppose.

I must admit I was very tempted to supply the following myself:
sed 's/[.,][^=.,]*$//' infile

awk '{gsub(/[,.].*/, "",$2)}1' FS="=" OFS="=" infile

What other lines? I thought each file was one line...

If not, how about this?

awk -v ORS=" " 'LF != FILENAME { print FILENAME; LF=FILENAME }; {$1=$1} 1; END { printf("\n"); }' *.txt

You realize these are the UNIX forums, yes? :wall:

Either way is a complete no-op. The only point of it is to inform awk that the data has changed, so that it should translate the newlines into...

It would've been nice to know if those did what you wanted. If they don't, neither will the same thing written in awk! :wall:

ORS controls the output record separator, which is a newline by...

Try this:

awk '/\xA0/ { print FILENAME, FNR }' *.txt

nawk '{
for(i=1;i<=NF;i++)
if ($i ~ "^[2-3][.,][0-9][0-9]$" && $i>=2.30 && $i<=3.99)
print $i
}' myFile

Try: awk 'NR==FNR{print;next}!/EL/' header.txt input.txt

if s is not empty then s=s FS $i
if s is empty then s=x $i

if(s){
s=s FS $i
} else {
s=x $i
}


HTH
--ahamed

Try this...

awk '/^[0-9]/{match($0,"([0-9]*[; ]*[a-zA-Z].*)",a); $0=a[1]}1' input_file


--ahamed

if you have gnu sed maybe u can try this
$ sed '1~2s/.* \([^ ]* [^ ]* [^ ]* [^ ]*\)/\1/'

awk -F, '{for (i=2;i<=NF;i++) a[$i]=a[$i]==""?$1:a[$i] FS $1}
END{for (i in a) if (i>0)print i FS a[i]|"sort -n"}' infile

1,A1,A3,A4
2,A1,A3
3,A3,A4
4 3,A1
4,A4
5,A1,A3,A4
6,A1...

I guess the result need be sorted.
awk -F , '{for (i=2;i<=NF;i++) if ($i>=0) print $1 FS $i|"sort -t, -k1,1 -k2,2n"}' infile

A1,1
A1,2
A1,4 3
A1,5
A1,6
A2,7
A2,8
A2,9
A2,10
A2,11
A2,12...

this is not really a matrix transposition - this is a hybrid of some kind. And your desired output is not consistent - in particular the A3 and the A4 sequences...
A better/consistent example,...

It works for me though...

root@bt:/tmp# awk -F"," '
> {
> printf $1 FS
> for(i=2;i<=NF;i++)
> {
> if(!match($i,"/")){
> printf...