String chop

[ranjit]

How would I achieve the desired result below using awk. I wish to remove all characters from the second "-" onwards:

Input file:
tqharvc -d EDB_PRODUCTION -T 4
tqhrrpvc -d EDB_PRODUCTION2 -T R1

Desired result:
tqharvc -d EDB_PRODUCTION
tqhrrpvc -d EDB_PRODUCTION2

Thanks

 

[PHV]

A sed way:
sed 's!-[^-]*$!!' /path/to/input >output

An awk way:
awk '{sub(/-[^-]*$/,"");print}' /path/to/input >output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, missread the OP.
Either:
[tt]sed 's!-[^-]*!!2'[/tt]
Or:
[tt]awk -F- '{print $1"-"$2}'[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886