delete and remain 2 value

happyv · #1 (**permalink**) 05-25-2007

Hello Friend,

I have the followint command to delete 4th field and move forward. Can I delete all filed and just remain the first 2?
sed -e "/^[ ]*<Number/s/\([^ ]\) \([^ ]\)/\1\2/g" -e "/^[ ]*<Number/s/\([0-9][0-9][0-9]\)./\1/" -e "/^[ ]*<Number/s/\([0-9][0-9]\)/\1 /g" -e "/^[ ]*<Number/s/0</</" file

input
<Number>00000000<Number>
<Number>0123456<Number>
<Number>4403459411<Number>

output
<Number>00<Number>
<Number>01<Number>
<Number>44<Number>

vino · #2 (**permalink**) 05-25-2007

Code:

sed -e "s/\(<[^>]*>..\)[^<]*\(<[^>]*>\)/\1\2/g" file

If you believe in 'beauty in brevity'

Code:

sed -e "s/\(>..\)[^<]*/\1/g" file

happyv · #3 (**permalink**) 05-25-2007

Quote:

Originally Posted by vino

Code:

sed -e "s/\(<[^>]*>..\)[^<]*\(<[^>]*>\)/\1\2/g" file

If you believe in 'beauty in brevity'

Code:

sed -e "s/\(>..\)[^<]*/\1/g" file

thx, but the file have many different fileds should as <customer>, <price>, etc
I ONLY need to do <Number>, how your settlement work for this?

vino · #4 (**permalink**) 05-25-2007

Quote:

Originally Posted by happyv

thx, but the file have many different fileds should as <customer>, <price>, etc
I ONLY need to do <Number>, how your settlement work for this?

Then it becomes much simpler

Code:

sed -e "s/\(<Number>..\).*\(<Number>\)/\1\2/g" file

ghostdog74 · #5 (**permalink**) 05-25-2007

Code:

awk '
    { if  (match($0,"<Number>")){
            print substr($0,0,RLENGTH) substr($0,RLENGTH+1,2)"<Number>"           
      }
    }' "file"

happyv · #6 (**permalink**) 05-25-2007

Thanks all. It work.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
ld: fatal: relocations remain against allocatable but non-writable sections	tdallagn	SUN Solaris	0	05-21-2008 07:58 AM
how to delete content in a file (delete content only)	kittusri9	Shell Programming and Scripting	5	05-15-2008 01:12 PM
Delete ^ using sed	us_pokiri	UNIX for Dummies Questions & Answers	5	04-22-2008 01:20 AM
Can't delete anything in /usr	ms1951	UNIX for Dummies Questions & Answers	4	10-22-2004 11:49 AM
delete	lesstjm	UNIX for Dummies Questions & Answers	3	11-08-2001 03:24 PM

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