I have a requirement to convert rows into columns. data looks like:
and so on..
output shud be like this:
Thanks in advance,
Hi , I want to compare first 3 columns of File A and File B and create a new file File C which will have all rows from File B and will include rows that are present in File A and not in File B based on First 3 column comparison.
I redirected running of my scrip to a file, and I can see it well when I use cat command.
But in the vim or Microsoft word, it is cluttered :rows and columns and the tabs between columns!
and some things like ^[[32m is shown in the file!
Is there any way to convert it correctly?
I need it to show in the windows 7 format file.
I have 2 files,
file01= 7 columns, row unknown (but few)
file02= 7 columns, row unknown (but many)
now I want to create an output with the first field that is shared in both of them and then subtract the results from the rest of the fields and print there