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 / Word / Conversions / March 2004

Tip: Looking for answers? Try searching our database.

Coverting "Space-Delimited" TXT File to Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Larry R Harrison Jr - 08 Mar 2004 18:00 GMT
I have Word 2003. I have a RPT file (Crystal Reports-generated, I think)
which needs to be imported and formatted. It is in "space-delimited" format,
with a layout like this:

************************************************************
Comp    Date      Warr#            AMT  ACCOUNT DESCRIPTION

XYZ      1/2/2004 22614105   195.36   TOOLS & EQUIP UNDER $1000
                                               190.08   TOOLS & EQUIP UNDER
$1000
                                               190.08    TOOLS & EQUIP
UNDER $1000
                                                95.04     REPAIR & MNTNCE
SUPPLIES
                                                179.52   TOOLS & EQUIP
UNDER $1000
************************************************************

It is "space-delimited," meaning that rather than having commas or tab stops
between each field/column, it's a bunch of spaces.

The tricks:

(1) It needs to be imported into Word, formatted to look like that
(2) It needs to end up in as "plain" a format as possible--not in table
format, rich text etc
(3) It's okay if "XYZ" and date etc information doesn't repeat when it
doesn't change
(4) The biggie--a macro (in Visual Basic I assume) needs to do all that with
the click of a button

I am able to write Visual Basic all day long in Access, and I can do simple
ones in Word--but funky ones like this in Word, it's beyond me.

Where are some websites which can explain how? Anyone have any ideas
themselves?

LRH
macropod - 10 Mar 2004 08:01 GMT
OK, so why not simply copy into word and format the data as Courier New?
Can't get much simpler than that.

Cheers

> I have Word 2003. I have a RPT file (Crystal Reports-generated, I think)
> which needs to be imported and formatted. It is in "space-delimited" format,
[quoted text clipped - 34 lines]
>
> LRH
 
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.