Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amstel123

    AWK command for 2 file merge

    awk '{FS="|"}{OFS="|"} NR==1{for(i=1;i<NF;++i)n1=" na"n1} NR==FNR{a1[$1]=substr($0,length($1+$2+$3+$4+$5)+1);t[$1];next} FNR==1{for(i=1;i<NF;++i)n2=" na"n2} {a2[$1]=substr($0,length($1+$2+$3+$4+$5)+1);t[$1];next} END{for(i in t)print i (i in a1 ? a1[i] : n1) (i in a2 ? a2[i] : n2) | "sort"} '...
  2. amstel123

    AWK command for 2 file merge

    New to Awk usahe , So hadn't much luck
  3. amstel123

    AWK command for 2 file merge

    Hi, Could anyone help with command wher i need to merge two file with variable number of records based on matching records File1 ******* F1|F2|F3|F4|F5|F6|F7|F8|F9|F10|F11|F12 .. .. .. N records File2 ***** F1|F2|F3|F4|F5|F13|F14|F15 .. .. .. M Records I need the output as File3...

Part and Inventory Search

Back
Top