Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

Solved

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

Posted on 2013-01-06

1 solution

Medium Priority

270 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

Comment

Question by:wuanchu

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 86

Accepted Solution

by:Mike Tomlinson

Mike Tomlinson earned 2000 total points

ID: 387488092013-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

Author Comment

by:wuanchu

ID: 387694112013-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?

Featured Post

Question has a verified solution.

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

Key concepts of Delegate using C#

Article by: ROMA

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…

Did you know that C# foreach statement is your enemy in games development?

Article by: Giuseppe "Pino"

Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.

Bar Graphs in an Access Query

Video by: crystal

Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

Percona Server for MongoDB

Video by: Percona

In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …