Search Results

Note that neither the sample input nor the sample output you provided contained any tab characters. The following will work with fields separated by any combination of one or more commas, spaces,...

sed -r 's#(\w+)com#\1\.com#g' infile

Or this one?
awk 'BEGIN {OFS=FS="\t"} {s=""; for (col=2; col<=3; col++) {sep=""; n=split ($col,T,"[ ,<>]+"); for (i=1;i<=n;i++) if (NR==1 ||...

Not clear. Please rephrase carefully.

EDIT: Guessing wildly:awk 'BEGIN {OFS=FS="\t"} {n=split ($3, T, " "); $3=""; for (i=1;i<=n;i++) if (T[i]~/www|http|ftp|mailto|Text/) $3=$3 T[i];print $2,$3}'...

# awk -F'[ ;]' 'NR==FNR{a[$1]=$2;next}{for(i=1;i<=NF;i++)if(($i in a))for(j in a){print $1,j,a[j];next}}' filea fileb
バーストリミット sm982882 sm1893548


regards
ygemici

Hi, you were on your way, but you need to distinguish the phases in which you are processing filea or fileb. When NR is equal to FNR, awk is processing the first file which in this case is fileb....