I need to import a text file into excel and do the following :
This text file is broken into “Information on object # 1 through #35. In each of these objects I would like to extract the NAME row and SEGMENT LENGTH row and delete the rest. CAN ANY BODY HELP.
Some times these files are 1000's of objects so I need to automate it some how.
Thanks in advance for your help!
Last edited by lweng; 09-16-2010 at 12:15 PM.
Here you go.
A very straight forward way:
Select Column C and D Copy paste special values
Delete Column A and B
Sort columns A and B by A descending.
edvwvw
Give this a try:
Please Login or Register to view this content.
Last edited by JBeaucaire; 09-16-2010 at 12:07 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
--------------------------
Last edited by lweng; 09-16-2010 at 11:37 AM.
-----------------------------
Last edited by lweng; 09-16-2010 at 11:37 AM.
I got it working now! Thanks that’s exactly what I need. I appreciate your help. Could you make it so It deletes the (string) off the back side of the segment length column? And add a column with the NAME? Thank you for your help!!!
Yes, this a macro.
How/Where to install the macro:
1. Open up a blank workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The macro is installed and ready to use.
A. Press Alt-F8
B. Select ImportObjectList from the macro list
C. The macro will prompt you to select the text file on your hard drive
D. The macro will do the rest
B.
I got it working now! Thanks that’s exactly what I need. I appreciate your help. Could you make it so It deletes the (string) off the back side of the segment length column? And add a column with the NAME? Thank you for your help!!!
Try this:
Please Login or Register to view this content.
Thank you… I appreciate your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks