Replace column in one file with column from another using awk?

by

try:

awk 'FNR==NR{a[NR]=$3;next}{$2=a[FNR]}1' f2 f1

Output:

111 000 444
222 111 555
333 555 666

Explanation of the above code:

  • FNR==NR allows you to work with one entire file at a time. In this case it is the file f2. NR and FNR both contain line numbers with the difference being FNR gets reset to 1 when a new file is read where as NR continues to increment.
  • While we are working with f2 file, we are creating an array called a using line number (NR) as the key and third column ($3) as the value. next allows us to skip the rest of the action block.
  • Once f2 file ends, we start to work on f1 file. NR==FNR condition will not become false as FNR will increment from 1 and NR won’t. So only second action block {$2=a[FNR]} will be worked upon.
  • What this block does is it re-assigns second column value to array value by looking up the line number.
  • 1 at the end prints the line. It returns true, and in awk true statements results in printing of the line.
  • f2 f1 is the order of files defined. Since we want to create an array from file f2 we put that first.

More Related Contents:

  1. How can I do a recursive find/replace of a string with awk or sed?
  2. How to swap text based on patterns at once with sed?
  3. Remove all text before colon
  4. How do I find and replace all occurrences (in all files) in Visual Studio Code?
  5. Find and replace in Visual Studio code in a selection
  6. Remove specific characters from a string in Python
  7. How to delete duplicate lines in a file without sorting it in Unix
  8. Java String replace not working [duplicate]
  9. PHP string replace match whole word
  10. How can non-ASCII characters be removed from a string?
  11. Fastest way to find lines of a file from another larger file in Bash
  12. Recursively rename files using find and sed
  13. How can I quickly sum all numbers in a file?
  14. Extraction of data from a simple XML file
  15. How to replace last occurrence of characters in a string using javascript
  16. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  17. Print all but the first three columns
  18. Sort a text file by line length including spaces
  19. How to use python-docx to replace text in a Word document and save
  20. Efficiently replace values from a column to another column Pandas DataFrame
  21. How to delete and replace last line in the terminal using bash?
  22. jQuery – replace all instances of a character in a string [duplicate]
  23. Check if all of multiple strings or regexes exist in a file
  24. Replace a word with multiple lines using sed?
  25. Replace substring of NSAttributedString with another NSAttributedString
  26. Find and replace in a file
  27. Remove everything from the first occurrence of a character to the end of a string in PHP
  28. How to print 5 consecutive lines after a pattern in file using awk [duplicate]
  29. JavaScript: replace last occurrence of text in a string
  30. How to remove blank lines from a Unix file

Leave a Comment