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

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

wuanchu

Asked: 2013-01-06

Advertise Here

1 Solution

LVL 86

Mike TomlinsonMiddle School Assistant TeacherCommented: 2013-01-06

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

wuanchuAuthor Commented: 2013-01-11

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?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

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

Join & Write a Comment Already a member? Login.

Featured Post