Search Results

awk '{i=$1;sub(i,x);A[i]=A[i]$0} FILENAME==ARGV[ARGC-1]{print i A[i]}' file*

from 'man awk':

ARGC The number of command line arguments (does not
include options to gawk, or the program source).

ARGV Array of command ...

Now I see :)

To the OP: you mean every two characters, not every two digits ...

---------- Post updated at 05:17 PM ---------- Previous update was at 05:10 PM ----------

And if you want to...

sed 's/../&,/g' myFile

awk 'NF<17{$(NF+1)=99999}1' infile

awk 'NF<17{$0=$0 FS 99999}1' infile

Verify your input file format. First post fields are separated by ","

so you can use

awk '{if($17==""){$17=99999};print $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17}' inputfile

or
you can do like this,

awk -F\, '$1>0{if($5==""){$5=99999};print $1,$2,$3,$4,$5}' inputfile

Awk should handle a different number of spaces between each field (as long as you have at least 1 space).

You may need to run another script over you input files to get the columns seperated,...

If there is no headings, it will be more simple:

awk 'NR==FNR {A[$1 FS $2]=$9 OFS $10; next}
$1 FS $2 in A { print A[$1 FS $2], $0; } ' OFS="\t" FileB FileA

Here you go

(With Fn headings in input files and output)
awk 'NR == FNR { A[$1"|"$2]=$9; B[$1"|"$2]=$10; OFS="\t" ; next}
FNR == 1 { printf...

awk -F'","' '$6""' infile ;)

---------- Post updated at 08:36 ---------- Previous update was at 08:29 ----------

grep \\. infile

If i understood correctly- In the input file the 6th column (with FS ,) of the shorter lines are- only double quotes " " whereas the longer lines has some values in 6th and the consecutive columns....

awk -F, '$6!="\"\"" ' infile

Hi.

Seems you've mixed up some sh and csh (if [[ `wc -l ${filen}` < 16 ]] is quite Bourne shell :) (except the < part)).


#!/bin/csh
set filen = `sh -c 'ls T 2> /dev/null'`
foreach fil...

Just send your file through: sed '...' <input >output

Enjoy!

Awk should be better at this, as it has field sense. I just lay out my commands so they are easier to review. White space is...

awk '(NR<3&&p=p (p?FS:x)$2)||$0=p FS$0' file

awk '(NR<3){A[NR]=$2}{print((NR>2)?A[1]" "A[2]" "$0:$0)}' inputor
awk '(NR<3){A[NR]=$2}{print((NR>2)?A[1]FS A[2]FS$0:$0)}' inputorawk '{A[NR]=$2;print(NR>2)?A[1]FS A[2]FS$0:$0}'...