Search Results

For data exactly like your sample data, this simple approach might do as well:awk -F, ' $1 in X {$1=X[$1]} {X[$2]=$1} 1' OFS="," file
Job1,JC1
Job1,JC2
Job1,JC3
Job1,JA1
Job1,JA4
JG,KA
Job1,JJ

Personally, when shell scripting using arrays for things like this, I prefer awk:
#!/bin/ksh
awk '
BEGIN { FS = OFS = "," }
NR == FNR {
tr[$2] = $1; next
}
{ while($1 in tr) $1 = tr[$1] }
1'...

With respects to Scrutinizer, if the XML tags are nested on the same line, are empty, have multiples on a line, or span multiple lines, as in:
<?xml version="1.0" encoding="UTF-16"?>
<P1 >
<C1...

With this particular format you could try:
sed 's/<\([^>]*\)>\(<[^>]*>\)$/\1\2/' file

The issue will be determining what is a valid XML tag and what is data that appears between "<" and ">". Is it always numeric? Are there negative numbers? Character strings? With or without...

how about this:
awk -F, '
BEGIN { cols=split("A,B,C", a);}
{ c[$1];v[$1,$2]+=$3 }
END {
printf "XX"
for (i=1;i<=cols;i++) printf ",%s", a[i]
printf "\n"
for (j in c) {
...

Two suggested modifications to ritakadm's approach:
val[$1,$2]+=$3
and
val[j,i]+0

Not the most elegant solution, but try this,,untested..sorry i missed on the sum part...


awk -F, '{a[$1","$2]+=$3;}END{for(i in a)print i", "a[i];}' file > infile


awk -F, '{cntry[$1];...

Here is an awk approach:
awk -F, '
{
D[$1,$2,$4,$6]++
R[$1,$2,$4,$6] = R[$1,$2,$4,$6] ? R[$1,$2,$4,$6] RS $0 : $0
}
END {
...

awk -F "<VName>|</VName>" '{s=s?s"\n"$0:$0}
/^<BOOK><Info>/{fn=$2}
/<\/BOOK>$/{print s > fn ;s=""}' file

$awk -F"\"" 'BEGIN{i=1;print "Id,Name,Prompt"} ($1 ~ /Id|Name|Prompt/){if(i==4){print x;i=1};i++;printf $2","}END{print x}' inputfile

awk -v c="Id Name Prompt" -v OFS=, 'BEGIN {
n = split(c, t)
for (i = 0; ++i <= n;) {
printf "%s", (t[i] (i < n ? OFS : ORS))
v[t[i]]
}
}
$1 in v { get_val($1) }
/END RECGET/...