We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Drag an area with mouse in a text file and split the text into columns with highlighted color
Posted on 2013-01-06
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:512010
122335SatOct2315:37:512010
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
121335SatOct2315:37:512010
122335SatOct2315:37:512010
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
[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
2 Comments
Active today
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:
...and the Project ZIPPED up:
Visual-Fixed-Width-TextFile-Impo.zip
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:
...and the Project ZIPPED up:
Visual-Fixed-Width-TextFile-Impo.zip
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Create simple VB.net Add-in for Excel in Office 365 | 2 | 60 | |
| Read oracle BLOB in vb.net | 2 | 24 | |
| I'm looking for a dynamic length jQuery/javascript currency editor mask? | 2 | 65 | |
| sql server connection string in config file | 4 | 41 |
Creating an analog clock UserControl seems fairly straight forward. It is, after all, essentially just a circle with several lines in it! Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month4 days, 8 hours left to enroll
739 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.