Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2006

Tip: Looking for answers? Try searching our database.

Query on a text file..help needed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MaryLindholm@gmail.com - 17 Oct 2006 18:20 GMT
I am trying to query a large text file and I'm beginning to wonder if
it is just impossible to do.

I used the excel query wizard but because I am working with a fixed
length file I am not coming up with the columns I need.  The wizard
picks up each row as a solid block of information.  Is there a way to
pick out certain information from the text file into the query?

so if my text line reads:

0110172006johndoe234street

excel could pick out
01 10/17/2006 John Doe 234 street

I know someone ran a query on my file and put it into the most
beautiful excel spread sheet but it just isn't working for me.
CLR - 17 Oct 2006 18:41 GMT
If all of your data are in that same format down comumn A, then you could use
Data > TextToColumns to break some of it apart, and then use some of the TEXT
formulas like LEFT, RIGHT, MID, FIND, etc to get the rest of it.....

Vaya con Dios,
Chuck, CABGx3

> I am trying to query a large text file and I'm beginning to wonder if
> it is just impossible to do.
[quoted text clipped - 13 lines]
> I know someone ran a query on my file and put it into the most
> beautiful excel spread sheet but it just isn't working for me.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.