Avatar of wuanchu
wuanchu
 asked on

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
Visual Basic.NETC#

Avatar of undefined
Last Comment
wuanchu

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mike Tomlinson

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
wuanchu

ASKER
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?
Your help has saved me hundreds of hours of internet surfing.
fblack61