Unix Find & Replace Issue

Question

I have a pretty huge .csv file with the date at column 3 ( Example: 11/17/2015) and i need to replace with the date format as 2015-11-17. I tried doing using:%s/\<11/17/2015\>/2015-11-17.But couldn't see the change. Any suggestions on how to do this?.

David · Accepted Answer · 2015-11-18 09:56:33Z

1

I assume you are using vim:

:%s/11\/17\/2015/2015-11-17/g

You can do this also with sed without opening the file:

sed -i 's/11\/17\/2015/2015-11-17/' somefile.csv

answered Nov 18, 2015 at 9:56

David

4043 silver badges15 bronze badges

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

Comments

SMA · Accepted Answer · 2015-11-18 09:56:29Z

1

Try to escape backslash like:

echo "11/17/2015" | sed 's/11\/17\/2015/2015-11-17/g'
2015-11-17

answered Nov 18, 2015 at 9:56

SMA

37.2k8 gold badges53 silver badges76 bronze badges

Collectives™ on Stack Overflow

Unix Find & Replace Issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related