Add Comma After Each Line
Advertisement

In this article we will go through the steps required to add comma after each line, the same steps can be used in both Mac or Windows using any of the commonly used code editors like Atom or Sublime text.

Advertisement

You may even use the solution to remove a comma or even better add/remove other symbols or content after each line.

Welcome to to Mr. Virk Media, I am your host Navjot Virk. And will be walking you through the steps.

Add Comma After Each Line

Learn using a sample use case or Move Straight to Steps HERE

Use case: I have an excel dataset that contains public companies info like ticker symbol, industry etc.

But, I am interested in created an online portfolio on say Yahoo Finance which requires comma separated ticker symbols for multiple entries, and off-course I am not interested in inserting data individually (maybe I am lazy or want to save time & energy or their maybe just too much data to work with, any the case I think their is no point going one by one if you can do it all at once and more effectively).

Sample Data

Sample Data for Adding Comma After Each Line

I will be taking all the ticker symbols.

Steps

Note: In this example, I will be working with Atom on a Mac (you may choose an editor of your choice). If you are on a Windows Computer please use Ctrl (control) button on your keyboard instead of Command and you should be able to achieve the same results.

Let’s start, open your code editor with data you would like to work with, below, I have have isolated all the ticker symbols I am interested in working with.

Step 1: Select all the data using Command + A on your keyboard

Command + A to Select all text in Mac

Step 2: Press Command + Shift + L to split data into lines, this will allow you to work at the end of each line.

how to split data into lines

Step 3: Using the Arrow key → navigate to end of the line, and add comma or any other content of your choice.

Add Comma After Each Line in Mac or Windows

Add Comma or Something at the Start of Each Line

Now if you had use-case where you wanted to add comma at the start of each line, you would just want to simply navigate to start of line using the ← symbol on the keyboard

Video Tutorial

PS.

List of Commonly used Text/Code Editors you may use

For anyone new to code editors, here is a list of commonly used editors – Atom, Sublime Text, Visual Studio Code

Hope this helps save you some time, you should also checkout our homepage for more useful articles like this here.

You can also share the article to show appreciation, if you loved the content on this page. Thanks it really helps me grow and continue helping people across the globe.

Advertisement
Navjot is a Hobby Blogger from Ireland, and loves to create content to help people. He makes time on weekends to work on this blog. And has a full time position at Verizon Media as Technical Solutions Consultant, which he loves and thrives at. His Skills include in-depth knowledge of SEO, Javascript, Advertising, HTML and Java.