[SOLVED] Remove all lines containing 'A,,,,,,'

hattori.hanzo · 11-03-2010, 09:16 PM

How can I remove all lines which contain A,,,,,,

I tried the following sed statements but no luck.

Code:

sed "/A,,,,,,/d file"
sed "/A\,\,\,\,\,\,/d file"

Thanks & Regards

neonsignal · 11-03-2010, 09:59 PM

Quote:

Originally Posted by hattori.hanzo

Code:

sed "/A,,,,,,/d file"
sed "/A\,\,\,\,\,\,/d file"

You just have a misplaced quote, you only need to quote the sed command, not the filename, ie:

Code:

sed '/A,,,,,,/d' file

hattori.hanzo · 11-03-2010, 10:06 PM

Apologies, typo on my part.

Still doesnt appear to work tho.

Code:

sed '/A,,,,,,/d' file

crts · 11-03-2010, 10:25 PM

Quote:

Originally Posted by hattori.hanzo

Apologies, typo on my part.

Still doesnt appear to work tho.

Code:

sed '/A,,,,,,/d' file

Well, since the sed is correct you will have to provide some sample data. Miscounted the number of ','? Any whitespaces in between ...?

hattori.hanzo · 11-03-2010, 10:29 PM

OK. Here is a sample. I need to remove the middle line.

Code:

2010-10-04 00:07:33,9780009689,57641534,A,com,d,c,b,,
2010-10-04 00:07:35,3867802220,179041534,A,,,,,,
2010-10-04 00:07:36,7860502220,988941534,A,com,d,c,b,a,

Thanks & regards

crts · 11-03-2010, 10:37 PM

Just copy+pasted your sample data, then copy+pasted the sed command and it works perfectly.
Maybe you want the -i option to modify the file permanently?
sed -i '/A,,,,,,/d' file

hattori.hanzo · 11-03-2010, 11:09 PM

Its resolved thanks.

I had this statement in the middle of a script which didnt work so I changed it. But it definitely works works as expected at the command line. Thanks.