Shell Programming and Scripting

I have text file with lines as shown here. Each row has 11 columns separated by tab. In each row, i want to split the 8th column such that the output should look like shown below. Here value in the 9th column is DP value and in the 10th column is MQ value followed by the values after resource.EFF=.
chr1 412573 . A C 2758.77 . 71 58.36 INTERGENIC MODIFIER GT:ADP:GQ:PL 1/1:0,71:71:99:2787,214,0 GATKSAM

chr1 602567 rs21953190 A G 5481.77 . 152 59.09 SYNONYMOUS_CODING LOW SILENT gaT/gaC D1034 ADNP2 protein_coding CODING ENSCAFT00000000008 5 GT:ADP:GQ:PL 1/1:0,151:151:99:5510,430,0 GATKSAM


Which means the 8th column has to be cleaned up such that, it has only DP value, MQ value and the information after resource.EFF= separated by tabs.

Could anyone help?

This sure looks a lot like another thread you started in this forum earlier today:Split column using awk in a text file

Am I missing something, or is this a duplicate posting?

Indeed the question looks similar, but the input format in the 8th column differs from the previous thread. To avoid confusion i have posted it as a new thread.

You can use previous thread solution to solve this

The previous solution

gives the output as

Here i want to split further

in first row into
similary the data in the second row
into
which means i want to replace () and | with tabs.

If you like to do lots of modification, its better to split it up and do some in one run and some other things in another run.
This reduce the complexity of the program

Running this on output above

Code:

awk '/INT/ {split($10,t,"[(|]"); $10=t[1]" "t[2]}{gsub(/[|()]/," ")}1'

gives

Code:

chr1 412573 . A C 2758.77 . 71 58.36 INTERGENIC MODIFIER GT:ADP:GQ:PL 1/1:0,71:71:99:2787,214,0

chr1 602567 rs21953190 A G 5481.77 . 152        59.09    SYNONYMOUS_CODING LOW SILENT gaT/gaC D1034 ADNP2 protein_coding CODING ENSCAFT00000000008 5  GT:ADP:GQ:PL 1/1:0,151:151:99:5510,430,0

This code is working only with first row. The second row remains the same. I want to replace the () and | in the 10th column in all the rows. i.e.
the data in the second row also should look like,