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

Using static IPs in Linux

By
It is often a requirement to assign static IP addresses to some important and permanent network interfaces. This is to avoid setting up a local DHCP server or relying on IP given by your network provider which may not be stable. This post shows steps to configure static IPs in Linux using Ubuntu 16.04 and Ubuntu 18.04 distros. We are considering two distros as network configuration has changed significantly in Ubuntu 18.04. There are two general steps to be followed: 1. Configure the network interface and assign a static IP. 2. Restart interface for the changes to take effect. Ubuntu 16.04  The current interfaces on the system are as follows: As can be seen, enp0s8 interface does not have any IP. Let's assign a static IP to it. In case you already have an interface with a DHCP assigned IP, you just need to change that IP and make it static. Edit the /etc/network/interfaces file and add the following code block. Prefer using the IP address range available for pri...
Post a Comment
Read more

Local domain name resolution using /etc/hosts

By
The /etc/hosts file is a powerful mechanism for managing the information about hosts in the local network in the absence of a local DNS server. Setup We have 4 VMs in the local /24 network. The following are the details: vm-1-ubuntu-16-04 - 10.0.1.11 vm-2-ubuntu-16-04 - 10.0.1.12 vm-1-ubuntu-18-04 - 10.0.1.21 vm-2-ubuntu-18-04 - 10.0.1.22 The VMs are reachable via their IP address but not by their hostnames. This is problematic because we have to remember their IP addresses everytime we want to access these hosts. It is would be much simpler to remember and access the servers by their hostnames. For that we need some sort of mapping between the IP addresses and their corresponding host names. There are 3 common ways of achieving this mapping. Setup a DNS server which handles resolution for your local network. Use an existing DNS server of the local Internet Service Provider (ISP) or any other higher level ISP. Note that a public static IP address is required for this s...
Post a Comment
Read more

Simple HTTP Server in Python

By
Have you ever come across a need to share a file over a local network to a number of machines? Have you ever felt the need to share output of a task in text files available at a web-endpoint? Often, there is a requirement to quickly setup a light-weight web-server for such requirements. Python provides the easiest way to setup a simple HTTP server for such use cases with a single command. Python comes pre-installed with Linux as many of the linux libraries use python in background. Therefore there is no extra overhead of installing python. With support for python2 getting stopped in April 2020, many of the newer versions of linux distros come with default python3. Therefore this post will focus on setting up an HTTP server using both python2 and python3. We will be using Ubuntu 16.04, however it will work for majority of the linux systems where python comes pre-installed. Preparation Steps to follow before starting the server: Make sure you are in the directory which you want ...
Post a Comment
Read more