Change two or more spaces to a single semicolon Change two or more spaces to a single semicolon shell shell

Change two or more spaces to a single semicolon


linux string shell replace 

$ sed 's/   */;/g' john doe   1900-01-01  california john doe;1900-01-01;california one space  two  spaces   three    spacesone space;two;spaces;three;spaces

linux string shell replace

Try using

sed -i 's/   */\;/g' your-file

This will substitute every 2 or more spaces with a ; in the file you pass it.

linux string shell replace

The best way is to query your database tables with the proper delimiter (ie ";"). See if you can do it that way. Otherwise, 

$ echo "john doe 1900-01-01 california" | sed 's/ /;/2g'john doe;1900-01-01;california

This will break if the name has 3 or more words.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last