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 / Setup / March 2004

Tip: Looking for answers? Try searching our database.

Excel Script...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ron - 25 Mar 2004 21:36 GMT
Hello

Would there, by chance, be available a script one could download and use to separate out text when importing it into a spreadsheet

My question is I have a text file and when I try to import it into the Excel spreadsheet (following the wizard's instructions), it does not separate everything out exactly as I want. Would anyone know of a program available that allows you to open an existing text file and specify how you want it separated out

Your help is greatly appreciated

Thank you!
Gord Dibben - 25 Mar 2004 22:59 GMT
Ron

If the Text Wizard can't do the job your data must be parsed out by some other
method.

There are many ways to do this, all dependant upon your data.

Post some examples of the text so others can help.

Gord Dibben Excel MVP

>Hello,
>
[quoted text clipped - 5 lines]
>
>Thank you!
Ron (re: Gord) - 26 Mar 2004 14:41 GMT
Hello Gord

Below is some example data as it is layed out at this time

12345678901234    5678901234567890123456789012BEATLE B BAILEY               1234 ERIE INDIANA
                             WALLA WALLA            WA123450000 1234567890123

This is the format of ALL data in the text file. Below is how the data is to be broken up

CYC-DATE        position 1-
CERT-NUM        position 6-1
ICN             position 19-3
GROUP           position 34-4
GROUP-BU        position 43-4
MEM-NAME        position 47-7
ADDRESS-PART1   position 73-10
ADDRESS-PART2   position 103-12
CITY            position 129-15
STATE           position 152-15
ZIP             position 154-16

Does this help? Let me know if you have more questions

Thank you

Ron
Dave Peterson - 27 Mar 2004 05:26 GMT
That sure looks like fixed width format to me.  What does excel do incorrectly?

> Hello Gord,
>
[quoted text clipped - 22 lines]
>
> Ron

Signature

Dave Peterson
ec35720@msn.com


Rate this thread:






 
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.