UNIX for Dummies Questions & Answers

I have a script that Cats a flat database file which contains 12 columns into sed. I want to add a 13th column which includes " ,2005-08-29 " * The date needs to be the current date.

This 13th column would be appended to the end of each line.

Does anyone have a clue how to do this using SED?

I dont think you need to use a cat or sed for that.

It can be as simple as this.

Code:

while read line
do
echo "$line ,$(date +%Y-%m-%d)" >> flatfile.new
done < flatfile

flatfile is your flat database file.

Vino

If you need to use sed, use this

Code:

sed -e "s#\(.*\)#\1 ,$(date +%Y-%m-%d)#g" flatfile > flatfile.new

vino

Here is my current command which works:

[root@localhost ds1f]# cat /mnt/winbox/list_measurement/ds1c/ds1_f.rome_27A03A 2>> error_log | sed '1,3d;s/^/27A03A,/;s/$ > /mnt/winbox/ds1_f.rome_27A03A

I tested the above sed command and here is its response

Ran this ---->
[root@localhost ds1f]# cat /mnt/winbox/list_measurement/ds1c/ds1_f.rome_27A03A 2>> error_log | sed '1,3d;s/^/27A03A,/ | sed -e "s#\(.*\)#\1 ,$(date +%Y-%m-%d)#g" > /SBS/list_measurement/ds1c/ds1_f.rome_27A03A

Reply was this ------>
sed: -e expression #1, char 19: unknown option to `s'

Code:

FILE="list_measurement/ds1c/ds1_f.rome_27A03A"

[root@localhost ds1f]# cat "/mnt/winbox/$FILE" 2>> error_log | 
sed -e '1,3d;s/^/27A03A,/' -e "s#\(.*\)#\1 ,$(date +%Y-%m-%d)#g" > "/SBS/$FILE"

vino

Vino...Thank you sooo much for your help...

Here is the command i have that works:

[root@localhost ds1c]# cat /mnt/winbox/list_measurement/ds1c/ds1_f.rome_27A03A 2>> error_log | sed -e '1,3d;s/^/27A03A,/' -e "s#\(.*\)#\1 ,$(date +%Y-%m-%d)#g" > /SBS/ds1_f.rome_27A03A

Here is the Results

,2005-08-29dale,3:02 am MON AUG 29, 2005,6:25 pm SAT JUN 25, 2005,08/28,03:09,0,0,0,0,N/A,N/A

Here is what i am looking for:

27A03A,orestdale,2:17 pm FRI AUG 26, 2005,6:25 pm SAT JUN 25, 2005,08/26,05:39,0,0,0,0,N/A,N/A,2005-08-29

all i need to do is put 27A03A, at the beginning of each line and ,2005-08-29