Can anyone give me the example of how to use awk or sed (not sure which one, as I haven't use either of these much, as I have mostly been using grep and cut to work with csv data) to convert differences between two .csv files into something more readable.
e.g. if I have a generated a diff from old and new .csv files, which in a real life could be much more complex because of a large number of columns:
2,3c2,3 < Barbara,1093,19 < Magdaline,2093,20 \ No newline at end of file --- > Barbara,1011,19 > Magdaline,12093,20 \ No newline at end of file
how could I convert it to this format:
Barbara 1093 1011 Magdaline 2093 12093
in a new format - a first column of data is a value from first column in both parts of the diff, to identify the line. Second column contains the data from the first csv file (old value) and third column - is the value from the second csv file (new value).
How can I perform such text conversion via awk or sed?