[AccessD] Re-Invent The Wheel??

Stuart McLachlan stuart at lexacorp.com.pg
Tue Oct 18 09:31:10 CDT 2005


On 18 Oct 2005 at 9:38, John Colby wrote:

> Gustav,
> 
> I certainly appreciate the "hard code" approach, I have doe that myself.
> OTOH, I have had a handful now that were fixed formats but needed
> "adjustments" to get it just right.  For example:
> 
> I am working on an export (and later an import) to the US government for
> what is called PlanD, having something to do with medicare re-imbursements
> to the city government.  The upload specification is VERY loosely defined,
> basically they say "fixed width (with field widths specified), comma
> delimited, with no header (field name) line, then they specify the format
> inside of date fields to be YYYYMMDD.  And THEN they say "if there is no
> data then you don't need anything in that field, but the commas must exist.

Yep, that certainly answers my question about whether there is such a thing 
as a fixed width, delimited file :-)

-- 
Stuart





More information about the AccessD mailing list