Fixed-Width Text Format

[Jeff]

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.

[Peter Duniho]

Re: Fixed-Width Text Format

On Tue, 27 May 2008 13:27:14 -0700, Jeff
<it_consultant1 @hotmail.com.NO SPAMwrote:

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

[Jeff]

Re: Fixed-Width Text Format

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

[Jeff Winn]

Re: Fixed-Width Text Format

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_consultant1 @hotmail.com.NO SPAMwrote in message
news:uArF51DwIH A.2064@TK2MSFTN GP05.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
>

[Peter Duniho]

Re: Fixed-Width Text Format

On Tue, 27 May 2008 15:27:22 -0700, Jeff Winn <jwinn@nospam.c omwrote:

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