All the portion is separated by a new line or "type". Under the "type", I only need to focus on the data with "name" at the column3. For those that "name" at the column3 and column6 is marked as "+", the data of column4 and column5 can be maintained. While those that "name" at the column3 and column6 is marked as "-", the data of column4 and column5 should be reversed. It seems like awk able to archive these goal.
Thanks for any advice.
Hi Ygor,
Thanks a lot for your awk code suggestion.
It worked well.
but it seems like it can't separated all the portion by a new line based on "type" word.
my desired output:
Both of the output are quite close to each other except lack of the new line based on the "type" word. Do you got any idea to archive my desired output result?
Thanks a lot and again for your help.
Hi Jairaj,
Your awk code seems like still got a bit different to generate my desired output result?
Do you got other suggestion or advice to improve it?
Thanks again first.
I'm trying to edit your awk code to get my desired output result as well...