Help with awk Script

[Scott Frye_1]

I want to use awk on my data. Here are two lines (of several) to represent the data I have.

One month ago: Sep29 100% (10%) <---- *HIGH*
One week ago: Oct22 100% (-2%) <---- *HIGH*

I want the number in parentheses without the '%' but with the '-'.

Any help would be appreciated.

Thanks

Scott

[Sanjay_6 · Accepted solution]

Hi Scott,

assume the file is /tmp/test

cat /tmp/test
One month ago: Sep29 100% (10%) <---- *HIGH*
One week ago: Oct22 100% (-2%) <---- *HIGH*

Try this,

cat /tmp/test |tr -d "()"|cut -f 2 -d "%"

this will give you the output.

10
-2

Hope this helps.

Regds

[Scott Frye_1]

works like a charm!

Thanks