Export ASCII delimited with some padded fields

Michael Schwartz (PC Support & Services) filepromike at gmail.com
Thu Jun 6 11:44:27 PDT 2019


> Seems like you really want to use fixed length fields?
> 
> Regards,
> 
> Scott
> 
> 
> Is it possible to export to a delimited file and pad a few of the fields
> with spaces?  The command I'm using is:
>
<snip>.
> Here's a sample of what I'm trying to do:
> ISA*00*          *00*          *12*1111111111TEST *12*2222222222TEST
> *190528*1447*U*00401*000001036*0*P*>~
> 
> Here's what it's doing:
> ISA*00**00**12*1111111111TEST*12*2222222222TEST*190528*1447*U*004
> 01*00000103
> 6*0*P*>~
> 
> Thanks,
> Josh

Hi Scott:

      I've run into this several times; mostly with insurance companies that
have old computer systems.  They need fixed length fields, but want an "odd"
delimiter between each field.  I've asked different companies why they need
this, but the olny answer I got back from all of them is, "That's how our
computer systems were originally designed..."

Mike Schwartz
 







More information about the Filepro-list mailing list