Re: how can I save a file with a single space delimeter

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Myrna Larson (anonymous_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 17:17:30 -0500

Fixed-record length files have, as the name says, a fixed length for each
record. They also have a fixed length for each field (column). If the data in
the column is too short, it's padded with spaces. If too long, it's truncated.
This type of file does use a delimiters in the strict sense of the word. A
field begins at a certain position in the record, say position 27, and it's,
say 10 characters long. i.e. characters 27-36 represent this field. No spaces
are needed at all. If all fields are the the specified length, the file would
contain no spaces at all (other than embedded spaces in a text field).

I guess "Speedy" is after the equivalent of a CSV file, but with a space
between fields instead of a comma. Excel can't do that automatically. You'd
have to write the VBA code yourself.

On Mon, 11 Oct 2004 16:30:59 -0500, Dave Peterson <ec35720@msn.com> wrote:

>If you're very good, you can save your file as:
>"Formatted Text (Space delimited)(*.prn)"
>(under the save as Type box on the file|SaveAs dialog.)
>
>I like to change my font to Courier New and adjust columnwidths. Then check
my
>output in my favorite text editor. (It's easy to screw up when adjusting the
>columnwidth.)
>
>But what you wrote would imply that each field is already the same
length--and
>contains no spaces?
>
>I'm not sure what happens when you have a field that varies in length--do you
>keep only one space as the delimiter or do you keep it fixed width?
>
>speedy wrote:
>>
>> I need to save a fixed record length file that has a single space between
>> each field is there any way this can be done?

Relevant Pages

  • Re: Label Mail Merge puts each line of address on a new label
    ... I don't understand why the delimiters are printing out since they should be ... special characters. ... If it's in Publisher, that may just be a display of ... >>> after I changed the record and field delimiters to those that Word ...
    (microsoft.public.publisher)
  • Re: Transfer table to fixed length text records
    ... it to detect the wrong number of characters per line. ... Are you sure this "well established" package is expecting a delimited ... file, not fixed length, and are you sure that you are using the exact ... same delimiters, for field, record and text, that this package expects? ...
    (microsoft.public.access.externaldata)
  • Re: Transfer table to fixed length text records
    ... Fixed length means NO delimiters of any kind. ... Your data is simply one massive string of characters. ... What I don't understand is that the text file size stays the same even though I have reduced the record size to say 298 or 299 to allow for line feed or carriage return characters. ... Are you sure this "well established" package is expecting a delimited file, not fixed length, and are you sure that you are using the exact same delimiters, for field, record and text, that this package expects? ...
    (microsoft.public.access.externaldata)
  • Re: Column Widths, Importing ANSI txt files
    ... delimiters where you want them. ... import "tell" excel to set Column A to 8 characters (and to pull those ...
    (microsoft.public.excel.misc)
  • Re: Saving permissions on files/folders (perl)
    ... I don't understand perl, but the file I get looks like this: ... > I don't see any delimiters in this data, which may be why the Restore script ... They are delimited by NUL characters. ... This looks like a quoting problem of your shell. ...
    (comp.unix.shell)