Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Drag an area with mouse in a text file and split the text into columns with highlighted color

Posted on 2013-01-06
2
Medium Priority
?
271 Views
Last Modified: 2013-01-12
I have a text file which some columns can't be split by space or comma or else, I want to split the text columns by dragging an area with mouse in part of the text ,then these columns in the whole text file  will be split into column and highlight the column with a different color. And the showing the column number while dragging the mouse. The data show below.
121335SatOct2315:37:51201099176399
122335SatOct2315:37:51201099176399

I want to split the data as below.

1 21 335 Sat Oct 23 15:37:51 2010 991 76399
1 22 335 Sat Oct 23 15:37:51 2010 991 76399
Thanks
0
Comment
Question by:wuanchu
2 Comments
 
LVL 86

Accepted Solution

by:
Mike Tomlinson earned 2000 total points
ID: 38748809
Attached below is a very old project I wrote in 2006 using VS2003.  I ran it through the wizard to upgrade it to VS2010:
http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_21704164.html#a15797962

It's not exactly what you're looking for, but it might give you some ideas on how it can be accomplished.

Here's a screenshot:
FixedWidth Column Import Example Screenshot
...and the Project ZIPPED up:
Visual-Fixed-Width-TextFile-Impo.zip
0
 

Author Comment

by:wuanchu
ID: 38769411
Thanks a lot. Very nice code, just like text to column in excel. Also could you try to draw an area and seperate the area into column and highlight the columns which defined by areas?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Suggested Courses

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question