How to replace a string on sed

Question

Hi i made a script which is take a data from my db and store it in to a .csv file

the contents of .csv file:

1-Mar-12,183991,1017  --- --- more columns are there
2-Mar-12,,,,,,,,,,,,
3-Mar-12,,,,,,,,,,,,
4-Mar-12,,,,,,,,,,,,
5-Mar-12,,,,,,,,,,,,
6-Mar-12,,,,,,,,,,,,

when i trying to replace a string depends upon the date it will add all corresponding dates.

for example

i want to replace a string on 2-Mar-12

command is

sed "s/$finddate/$finalstring/" dailyrep.csv > DailyReport_$datenow.csv


sed "s/2-Mar-12/$mydata/" origfile > fileto store

Output is

2-Mar-12,177950,8159,95.62%,6785711
3-Mar-12,,,,,,,,,
4-Mar-12,,,,,,,,,
5-Mar-12,,,,,,,,,
6-Mar-12,,,,,,,,,

11-Mar-12,,,,,,,,,,,,,,,,,,,,
12-Mar-12,177950,8159,95.62%,


21-Mar-12,,,,,,,,,,,,,,,,,,,
22-Mar-12,177950,8159,95.62%

I want to replace only that particular date not all occurrence of that.

kev · Accepted Answer · 2012-03-03 18:04:05Z

3

You can use this sed command:

$ sed "/^$finddate/s/$mydata/$finalstring/" dailyrep.csv

It only replace $mydata to $finalstring on lines which contain $finddate.

edited Mar 3, 2012 at 18:04

answered Mar 3, 2012 at 17:56

kev

163k49 gold badges286 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

icyrock.com Over a year ago

Try: sed "/^$finddate/s/$mydata/$finalstring/"

kev Over a year ago

You can add ^ to the pattern to match the beginning of line.

Christopher Neylan Over a year ago

Adding ^ the beginning of a regular expression means that the pattern will only match if it's at the beginning of the string. As you saw, sed matched any occurrence of '2-Mar-12', including '12-Mar-12', '22-Mar-12', etc. Adding ^ to the regex means it will only match lines that start with '2-Mar-12'.

Marko Kevac · Accepted Answer · 2012-03-04 06:02:59Z

1

^ in regular expressions means "beginning of the line". So what you need is to change "s/2-Mar-12/$mydata/" to "s/^2-Mar-12/$mydata/". It works not only in sed, of course.

answered Mar 4, 2012 at 6:02

Marko Kevac

2,9923 gold badges37 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to replace a string on sed

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related