Replace spaces with commas from one file and send the output to another file.
tr -s '[:blank:]' ', ' < input.txt > output.txt |
It’s perfect for creating a comma delimited file for importing to Excel.
replace
Vi Search and Replace
How to do search and replace in Vim.
Search for “foo” and replace it with “bar” in the current line. Use :s
:s/foo/bar/g |
Search for “foo” and replace it with “bar” in the entire document. Use :%s
:%s/foo/bar/g |
You can also pipe instead of forward slash. Useful if your search contains a /.
:%s|foo/|bar|g |
Modify a line using sed
Here’s how to modify a line in a file using sed.
sed -i 's/replace me.*/with this text/' /path/to/a/file.txt |
Replace spaces with comma
Here’s a simple sed command to replace multiple spaces into a comma delimited file.
sample.txt
one two three four |
The sed command.
sed 's/ \+ /,/g' sample.txt > sample2.txt |
sample2.txt
one,two three,four |
Mass Find and Replace
There are situations when you have to do a mass find and replace on your database. Let’s say you’re really, really bad speller. You just recently found out that you’ve been spelling a word for wrongly for years. To avoid embarrassment, you decide to do a search and replace. Unfortunately, you found out that there are hundreds of posts that contains that misspelled word. Instead of editing each post which is time consuming, you decide to run a mass find and replace against the database. In this example, we will replace the word ‘dawg’ with ‘dog.’
UPDATE wp_posts SET post_content = REPLACE ( post_content, 'dawg', 'dog'); |
I highly recommend that you back up your database first. I also recommend that you run it on a test database first before running it on a production environment, because a mass update is quite dangerous if you’re not sure what you are doing. If you’re a WordPress user, there’s a plugin called Search and Replace that will do the same thing. That might be easier for most people who don’t have access to MySQL command line or PHPMyAdmin.