Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • The perl one-liner will print the new record (with AUD) before the old one (with EUR) Commented Sep 23, 2013 at 13:41
  • Thanks Joseph, Just to add, How can I change the position of condition column, FOr example if the condition column is Col3 instead of Col5. Commented Sep 23, 2013 at 14:05
  • @user47766 see updated answer, the gawk one is easy to change, the Perl on is a bit more complex. Commented Sep 23, 2013 at 17:43
  • @user47766 Are we still talking about substituting EUR with AUD but a in a different column or will the patterns be different in this case? Commented Sep 23, 2013 at 18:13