Remove field starting with * and #

sumit207 · #1 (**permalink**) 06-30-2009

Hi

i have file with data:

abc,*xyz,#abc
123,#123,1234
*123,#123,abc

So i want to remove only fields starting with * and # and i want output as:

abc,,
123,,1234
,,abc

Please suggest something

Thanks
Sumit

ghostdog74 · #2 (**permalink**) 06-30-2009

next time, show what you tried.

Code:


awk -F"," '{
 for(i=1;i<=NF;i++){
    if($i ~ /\#|\*/){
        $i=""    
    }
 }
}1
' OFS="," file

sumit207 · #3 (**permalink**) 07-01-2009

i use dthe abov/e code but it is not working..

The entire row is getting blanks
so my output is 3 blank rows..

Pls suggest sumthing that can take care of this.

scottn · #4 (**permalink**) 07-01-2009

It works fine..

Code:

awk -F"," '{
>  for(i=1;i<=NF;i++){
>     if($i ~ /\#|\*/){
>         $i=""
>     }
>  }
> }1
> ' OFS="," file1
abc,,
123,,1234
,,abc

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
shell script to remove all lines from a file before a line starting with pattern	raksha.s	Shell Programming and Scripting	2	03-29-2009 08:13 AM
remove lines in text starting with . (period)	Movomito	UNIX for Dummies Questions & Answers	11	04-24-2008 11:19 AM
How to remove files starting with -	suman_jakkula	Shell Programming and Scripting	5	09-14-2006 01:43 AM
Field identification starting from the right	jhansrod	UNIX for Advanced & Expert Users	3	08-07-2005 02:38 AM
How To Remove files starting with -	rahulrathod	UNIX for Advanced & Expert Users	2	09-29-2004 04:19 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by