Hi..I have a file which looks like this:
2003.11.13,(h p computer) - FILTER: 1
2003.11.13,(marketing tool) - FILTER: 1
2003.11.13,(market tool) - FILTER: 1
2003.11.13,(market item) - FILTER: 1
2003.11.13,(avionics) - FILTER: 4
2003.11.13,(Proofs (printing)) - FILTER: 1
2003.11.13,(heart medication) - FILTER: 2
2003.11.13,(FOLIOS) - FILTER: 1
2003.11.13,(molded plastic) - FILTER: 1
2003.11.13,(PORTFOLIOS) - FILTER: 1
2003.11.13,(paint equipment) - FILTER: 1
2003.11.13,(portfolios) - FILTER: 1
In my output, I should see the lines without the starting "(" and ending "". So, my file should look like :
2003.11.13,h p computer - FILTER: 1
2003.11.13,marketing tool - FILTER: 1
2003.11.13,market tool - FILTER: 1
2003.11.13,market item - FILTER: 1
2003.11.13,avionics - FILTER: 4
2003.11.13,Proofs (printing) - FILTER: 1
2003.11.13,heart medication - FILTER: 2
2003.11.13,FOLIOS - FILTER: 1
2003.11.13,molded plastic - FILTER: 1
2003.11.13,PORTFOLIOS - FILTER: 1
2003.11.13,paint equipment - FILTER: 1
2003.11.13,portfolios - FILTER: 1
I have tried an awk..but, my awk results show me without "("..so, for
2003.11.13,Proofs (printing) - FILTER: 1, I see my output as 2003.11.13,Proofs printing)) - FILTER: 1
Can anybody help me please?
Thanks
2003.11.13,(h p computer) - FILTER: 1
2003.11.13,(marketing tool) - FILTER: 1
2003.11.13,(market tool) - FILTER: 1
2003.11.13,(market item) - FILTER: 1
2003.11.13,(avionics) - FILTER: 4
2003.11.13,(Proofs (printing)) - FILTER: 1
2003.11.13,(heart medication) - FILTER: 2
2003.11.13,(FOLIOS) - FILTER: 1
2003.11.13,(molded plastic) - FILTER: 1
2003.11.13,(PORTFOLIOS) - FILTER: 1
2003.11.13,(paint equipment) - FILTER: 1
2003.11.13,(portfolios) - FILTER: 1
In my output, I should see the lines without the starting "(" and ending "". So, my file should look like :
2003.11.13,h p computer - FILTER: 1
2003.11.13,marketing tool - FILTER: 1
2003.11.13,market tool - FILTER: 1
2003.11.13,market item - FILTER: 1
2003.11.13,avionics - FILTER: 4
2003.11.13,Proofs (printing) - FILTER: 1
2003.11.13,heart medication - FILTER: 2
2003.11.13,FOLIOS - FILTER: 1
2003.11.13,molded plastic - FILTER: 1
2003.11.13,PORTFOLIOS - FILTER: 1
2003.11.13,paint equipment - FILTER: 1
2003.11.13,portfolios - FILTER: 1
I have tried an awk..but, my awk results show me without "("..so, for
2003.11.13,Proofs (printing) - FILTER: 1, I see my output as 2003.11.13,Proofs printing)) - FILTER: 1
Can anybody help me please?
Thanks