Column Selection in Sublime Text

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.

Bring the cursor before "Column1"
For MAC users, press and hold control + shift and use down arrow key to select all the rows.
For MAC users, press and hold control + shift and use right arrow key to reach end of Column1.
Now use only right arrow key to reach the beginning of the next column.
Again press and hold control + shift and use right arrow key to select Column2.
For MAC users press command + x for cut, press down arrow key to go to desired location below.
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.

Comments

CRIF HighMark Credit Report Application Process

As per the RBI circular of 2017, you are entitled to get one free credit report every calendar year from each credit bureaus in India. CRIF HighMark is one of the four credit bureaus in India. This article will focus on creating a new account and getting your yearly free credit report. Visit the official website of CRIF HighMark https://www.crifhighmark.com/your-credit-score In the next screen, click on " Get Your Score Now" Register After registering, follow the below steps: Enter Personal Details Full Name DOB Email ID Mobile Number Gender Father's Name or Spouse Name Identification PAN or UID necessary Rest optional Communication Address CAPTCHA Review Terms of Use and Click Submit Choose free report Click " No Thanks, Take me to my FREE report " below the Upgrade me button. You will receive a confirmation email with your username and password and activation link. Click on activation link to...

My Entry into the World of Credit Cards

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...

Generate Large Files in Linux using dd

The programming community often requires large files for stress testing programmes. For example, sometimes such files are required to check the response time of certain programme or testing request handling capacity of servers. Many times, it does not matter what the contents of the file are, however, it is often difficult to find such large files when the need arises. Linux provides us a fast, efficient way of generating such huge files through simple command line options. For the purposes of this demo, I am using Ubuntu 16.04 and 18.04 linux distros. Ubuntu provides dd command to create such huge files in a matter of seconds. A typical dd command to create a 1 GB file is given below. dd if=/dev/zero of=big_file.txt count=1024 bs=1048576 parameters of dd: if - input file from which the content is read of - output file where the content is written count - number of blocks in output file bs - number of bytes in each block The above command creates a file named big_file.txt...

Shodh for Truth

Search This Blog