Skip to main content

Column Selection in Sublime Text

By
Have you ever wondered how to work with CSV (comma separated values) files if you don't have Microsoft Excel or similar softwares to handle tabular data? Have you even been asked to convert a table in text form to a csv or xlsx format? With Sublime Text, you can easily manage existing csv files or covert text files to csv files. Sublime Text is actually a text editor but it does much more than editing text! This post will help you select, move, adjust columns of a CSV (or text) file in sublime text. This can be used to convert tables created in text files into CSV.

Let us take an example CSV format as below
 

Let us select Column2 and paste it below.
  1. Bring the cursor before "Column1"
  2. For MAC users, press and hold control + shift and use down arrow key to select all the rows.
  3. For MAC users, press and hold control + shift and use right arrow key to reach end of Column1.
  4. Now use only right arrow key to reach the beginning of the next column.
  5.  Again press and hold control + shift and use right arrow key to select Column2.
  6. For MAC users press command + x for cut, press down arrow key to go to desired location below.
  7. Press command + v for paste.

That's it! Now you can adjust columns as per your need to create new tables and modify existing tables.
Labels:

Comments

Post a Comment

Popular posts from this blog

My Entry into the World of Credit Cards

By
After joining my job in June 2018, my salary account was opened in ICICI Bank. During the account opening process, I was offered a Life Time Free (LTF) credit card. Simply put, this was my first chance to get into the credit world without any extra hassle because first of all, neither was I aware of the concept of credit scores nor I had any credit history and secondly, I was just curious about credit cards after seeing of my father use his credit cards with extra caution and the monthly event of credit card bill payment that used to happen at my home. And in that sudden moment of joy, I made my first mistake in the credit world. Representative Image (Source: https://jessepollak.github.io/card/) Now if your guess is that I started spending crazy amounts of money which I couldn't repay, then you are WRONG! I am a miserly person. Money doesn't leave my hands and in general, my credit utilization has never exceeded 5% of my credit limit. So coming back to my first mis...
Post a Comment
Read more

ICICI Credit Limit Increase Offer

By
Recently, ICICI Bank offered me a free credit limit increase for my Lifetime Free ICICI Platinum Chip Credit Card. My limit is being increased by ~31%. For last couple of weeks, I was seeing increased available credit limit on my ICICI net-banking page. I also received an SMS stating that they are offering me a free credit limit increase, after the bill for the latest credit cycle was generated. The same limit enhancement offer is visible in iMobile app as well. See the last SMS message in the above screenshot In the Latest Bill tab you will see the Manage Limit option just above My Rewards. I have been using the card for around 10-11 months. Although this increase seems low, considering utilization, it seems fair. The highest credit utilization was around 15% once, while for the last couple of months, it was <1%. On average it was in 2-3% range. One can accept the increase through any of the three modes, SMS, netbanking or iMobile. It will immediately update the lim...
Post a Comment
Read more

The Japanese Constitution - Chapter 1

By
Chapter 1 - The Emperor Article 1 The Emperor shall be the symbol of the State and of the unity of the People, deriving his position from the will of the people with whom resides sovereign power. This article makes the post of emperor a symbolic one just like the post of Queen in UK or the post of president in a parliamentary democracy. It also emphasizes that the real power resides in the hands of people making it clear that there will be a democratic order of governance in Japan. Article 2 The Imperial Throne shall be dynastic and succeeded to in accordance with the Imperial House Law passed by the Diet. This article describes how the people will control the position of emperor through their elected representatives. Article 3 The advice and approval of the Cabinet shall be required for all acts of the Emperor in matters of state, and the Cabinet shall be responsible therefor. Article 4 The Emperor shall perform only such acts in matters of state as are provided for in th...
Post a Comment
Read more