Saturday, August 25, 2012

Extract Column Wise Data From A Text File

In general if you want to copy or cut data from a text file we can just drag it by mouse or we can use CTRL+C or CTRL+X. But this works only for row level. Some times we need to extract column wise. For example in an experiment we got text file in which we don't want some columns or if we copy some source code from internet it may consists unwanted number line.

In such cases let me tell the simplest technique to get data column wise data from a text file. For this we need a small software called notepad++. Now-a-days this is a very popular software and every body is having this. If you don't have this software
download here.

Steps to extract data:


Step 1: Open your text file in notepad++ (Or you can just drag and drop on to nodepad++)

Step 2: Keep your cursor at the starting point of the column which ever you want to extract/cut hold ALT button and drag it.
Step 3: Copy/Cut the data and Paste it in a new file.



Method : 2
If you have Microsoft word, then copy your text and paste in MS-Word. Hold ALT + left key, drag and copy text. It is the easiest and simple technique. 






Method : 3
If you have eclipse, open file in eclipse and hold press Alt+Shift+A, then editor turns into block editor, now select empty block that you want to delete and delete it.
Done

11 comments:

  1. hey nice source for us,thanks for sharing the nice topic of extract the data.And i found too many for the how to extract the data in easy way and this blog provide the amazing information .I definitely bookmark this blog.

    web data mining

    ReplyDelete
  2. We at Coepd declared Data Science Internship Programs (Self sponsored) for professionals who want to have hands on experience. We are providing this program in alliance with IT Companies in COEPD Hyderabad premises. This program is dedicated to our unwavering participants predominantly acknowledging and appreciating the fact that they are on the path of making a career in Data Science discipline. This internship is designed to ensure that in addition to gaining the requisite theoretical knowledge, the readers gain sufficient hands-on practice and practical know-how to master the nitty-gritty of the Data Science profession. More than a training institute, COEPD today stands differentiated as a mission to help you "Build your dream career" - COEPD way.

    http://www.coepd.com/AnalyticsInternship.html

    ReplyDelete
  3. We are the best web scraping company. Hire us to get 100% safe data extraction, data mining, and scraping. Visit us here
    data extraction services
    web crawling services
    web scraping services
    website scraper

    ReplyDelete
  4. Good article and blog. This article is really helpful, thanks for sharing this article with us

    Email and Phone Extractor Files.

    ReplyDelete
  5. Thanks for posting such a great post. It will help all of them. Keep maintain the updates.Digital Payment Platform|
    Digital payment integration

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete