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
I have a below data in a .csv file where all rows where col1 is A, col2 is odd numbers, similarly even numbers for all rows where col1 is B.
Note that my data has some other columns(not shown here) too (around 100) after col2.
I want to convert all odd numbers to even numbers( adding 1)..