Regex to substitude text

[ocon]

Hello All,

I was just wondering if someone with good experience in regex could help me, I am trying to remove a Goss and a dash from various lines but I am not sure how to achieve this.

For example I have to following lines on a txt file:
retention.dat:comment_data=goss- 1149803
retention.dat:comment_data=goss - 1149839
retention.dat:comment_data=goss-1150312
retention.dat:comment_data=12312 - Goss
retention.dat:comment_data=423553 -GOSS

In other words I just want to keep the number (maybe this could be another option, just print numbers after the '=' sign) removing all the variations of Goss.

Regards,
Carlos

[bluehive]

Hi Carlos,
If you want to do this in Python, it'll be fairly simple.

Read a line, convert it into a list. Now search for Goss and if there is a number after/before Goss, print it.

Blue

[ocon]

I am not good with Python, could you please provide a line as an example.

Thank you!
Carlos

[lomcevak]

You could use sed as follows:

sed -r 's/( *- *[gG][oO][sS][sS]|[gG][oO][sS][sS] *- *)//' filename

[ocon]

Thank you!

[ghostdog74]

if you have Python

#!/ussr/bin/env python
for line in open("file"):
    one,two=line.strip().split("=")
    t=[j for j in [i.strip() for i in two.split("-")] if str.isdigit(j)]
    print '='.join([one,t[0]])

[jaysunn]

You could use sed as follows:

sed -r 's/( *- *[gG][oO][sS][sS]|[gG][oO][sS][sS] *- *)//' filename

hello I attempted to do this and I am recieving the following error:

shine:bin jasonralph$ sed -r 's/( *- *[gG][oO][sS][sS]|[gG][oO][sS][sS] *- *)//' regex.txt 
sed: illegal option -- r
usage: sed script [-Ealn] [-i extension] [file ...]
       sed [-Ealn] [-i extension] [-e script] ... [-f script_file] ... [file ...]

I am on OSX and I used regex.txt as the input file. What am I doing wrong?

Jayusnn

[ghostdog74]

that simply means your sed version does not support -r

awk -F"=" '{gsub(/[^0-9]/,"",$2); print $1,$2}' OFS="=" file