Guest User

Untitled

a guest
Nov 16th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. awk 'NR==FNR{a[NR]=$0;next} {print a[FNR] "t",$5}' file1 file2
  2.  
  3. set -- file*
  4. fields="-f-5,$(seq -s, 10 5 $((5*$#)))"
  5. paste "$@" | cut ${fields%?} >outfile
  6.  
  7. awk -F "t" '
  8. { key = $1 FS $2 FS $3 FS $4; values[key] = values[key] FS $5 }
  9. END { for (key in values) print key values[key] }
  10. ' file ...
  11.  
  12. awk -F "t" '
  13. BEGIN { header = "col1" FS "col2" FS "col3" FS "col4" }
  14. {
  15. key = $1 FS $2 FS $3 FS $4
  16. values[key] = values[key] FS $5
  17. }
  18. FNR == 1 {
  19. split(FILENAME, a, /_/)
  20. header = header FS a[2]
  21. }
  22. END {
  23. print header
  24. for (key in values)
  25. print key values[key]
  26. }
  27. ' file ...
  28.  
  29. END {
  30. print header
  31. # order the array by index, as strings, ascending
  32. PROCINFO["sorted_in"] = "@ind_str_asc"
  33. for (key in values)
  34. print key values[key]
  35. }
  36.  
  37. awk '...' | {
  38. read header
  39. echo "$header"
  40. sort
  41. }
Add Comment
Please, Sign In to add comment