Help Needed -sed

ravi.sadani19 · #1 (**permalink**) 10-05-2006

Hi All,

i have one file and in that i have to read each line and do some replacement.
its is not fixed the number or column always be same it can be less also
exm
a;b;c;d;e;f (line)

i have to do something like
In the line
If c is present
then
go to end of line and append ';date'
else
go to end of line and append ';;date'

i am trying with sed command . but not actually gettin how to implement.
Kindly help me

reborg · #2 (**permalink**) 10-05-2006

Instead of trying to guess when your data actually looks like I would ask that you post a real sample ( multiple lines ) so that there is some possibility that a working solaution can be proposed.

ravi.sadani19 · #3 (**permalink**) 10-05-2006

input
121212;mrkt;share;UUU;SDS;C
121213;sales:trade;IMM;SSS;B;Cat;2222
121214;admin;books;CCC;DDD;D

look for Cat
if present
then
append ;date at end of line
else
append ;;;date at end of line

output
121212;mrkt;share;UUU;SDS;C;;;06102006
121213;sales:trade;IMM;SSS;B;Cat;2222;06102006
121214;admin;books;CCC;DDD;D;;;06102006

ghostdog74 · #4 (**permalink**) 10-05-2006

Python Alternative:

Code:

import time
thedate = time.strftime("%d%m%Y",time.localtime())
for lines in open("input.txt"):
        lines = lines.strip() #strip new lines
        if 'Cat' in lines:
                print "%s;%s" %(lines,thedate)
        else:
                print "%s;;;%s" %(lines,thedate)

Output:

Code:

/home> python test.py
121212;mrkt;share;UUU;SDS;C;;;06102006
121213;sales:trade;IMM;SSS;B;Cat;2222;06102006
121214;admin;books;CCC;DDD;D;;;06102006

ravi.sadani19 · #5 (**permalink**) 10-05-2006

Thanks,
But i looking a solution using unix shell script.Is it possible using sed command ??

ghostdog74 · #6 (**permalink**) 10-05-2006

yes, definitely, but you got to wait for a while.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
help needed	nnayagam	Shell Programming and Scripting	2	03-07-2008 06:34 AM
Little help needed.	Netghost	AIX	5	08-10-2006 02:29 PM
Help needed	dsravan	Shell Programming and Scripting	2	07-20-2006 09:37 AM
awk help needed.	cskumar	Shell Programming and Scripting	0	07-20-2006 07:24 AM
Sed help needed	stevefox	Shell Programming and Scripting	5	12-05-2005 01:44 AM

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