By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,928 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,928 IT Pros & Developers. It's quick & easy.

Fixed-Width Text Format

P: n/a
Hey

I'm wondering how the Fixed-Width Text Format is

What I know is that the top line in this text format will contain column
names. and each row beneath the top line represent for example a row in a
table etc...

But does fixed-with mean that every column has a fixed with: for example
first column is 10 char wide and second column is 30 char wide?

or does fixed-with mean something else?

I ask as I'm learning MIIS, and now are trying to import a flat file into
MIIS.

Jun 27 '08 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Tue, 27 May 2008 13:27:14 -0700, Jeff
<it************@hotmail.com.NOSPAMwrote:
I'm wondering how the Fixed-Width Text Format is
Um. Some context would be helpful.
What I know is that the top line in this text format will contain column
names. and each row beneath the top line represent for example a row in a
table etc...

But does fixed-with mean that every column has a fixed with: for example
first column is 10 char wide and second column is 30 char wide?

or does fixed-with mean something else?
I would guess that "fixed-width" means just that: a fixed width. That is,
one that doesn't change.

But, in what context are you asking the question? Where are you seeing
"Fixed-Width Text Format"? How is this used? It's entirely possible that
it means each column has its own fixed-width, or it could mean that all
columns have the same fixed-width. I don't see any way to tell the
difference unless you explain better the context.
I ask as I'm learning MIIS, and now are trying to import a flat file into
MIIS.
What's MIIS? Microsoft Identity Integration Server? That's the top
result on the MSDN search. How does that have anything to do with
fixed-width text formats, table displays etc.?

You will get much better answers if you don't assume we're mind-readers.
:)

Pete
Jun 27 '08 #2

P: n/a
What's MIIS? Yes it is Microsoft Identity Integration Server.
I'm learning MIIS 2003

In MIIS I can import data which are stored in flat files. 2 types of flat
files are supported:
delimited files and fixed-width files.

I think fixed-width, means that each column has a fixed width... I'll do
some more research around this. Read more in the MIIS documentation etc
Jun 27 '08 #3

P: n/a
Basically, a fixed width file format is a file layout that has the size of
each column predetermined when the file was generated.

Column A: 11 characters
Column B: 2 characters

And so on, when compared to a delimited file - delimited files use
characters in between each field to determine the stop and start positions
within the file to locate the columns whereas a fixed width file does not.
Fixed width files generally pad the rest of the column length with spaces to
ensure the layout remains consistent.

Fixed-width sample (using the above layout)
A1234567 AA
A2345678 BB

Delimited sample:
A1234567,AA
A2345678,BB

Delimited files generally also have what is known as text qualifiers around
them to further help locate the fields (in situations where the delimiter is
actually used as part of the field such as addresses).

Delimited sample with text qualifier:
"A1234567","AA"
"A2345678","BB"

HTH

"Jeff" <it************@hotmail.com.NOSPAMwrote in message
news:uA**************@TK2MSFTNGP05.phx.gbl...
What's MIIS? Yes it is Microsoft Identity Integration Server.
I'm learning MIIS 2003

In MIIS I can import data which are stored in flat files. 2 types of flat
files are supported:
delimited files and fixed-width files.

I think fixed-width, means that each column has a fixed width... I'll do
some more research around this. Read more in the MIIS documentation etc
Jun 27 '08 #4

P: n/a
On Tue, 27 May 2008 15:27:22 -0700, Jeff Winn <jw***@nospam.comwrote:
Basically, a fixed width file format is a file layout that has the size
of each column predetermined when the file was generated.
That's a fine general-purpose description. My guess is that the OP is
already familiar with the basic concept.

But can you tell us (well, him :) ), in the context of MIIS, when it
imports files in a fixed-width format, does MIIS support fixed-width files
where each column has its own width, or does each column need to be the
same width? More importantly, can you point to the place in the
documentation where this is specifically described?

Granted, I'm just guessing. But I think that sort of information would be
a lot more helpful to the OP than a general description of what a
fixed-width text file is.

Pete
Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.