Victoria,
I am assuming you have two recordsets that you want to interlace, typically
these are in header/detail fashion.
use an activescript task using the Filesystemobject and two recordsets and
follow this pseudocode
Flesh out and amend the code as needed.
do while not HdrRs.EOF
textfile.writeline HdrRs. Columns ( use a padding subroutine if needed)
fetch DtlRs where Dtl.keys = HdrRs.Keys
do while not DtlRs.EOF
textfile.writeline DtlRs. Columns ( use a padding subroutine if
needed)
dtlRs.MoveNext
loop
HdrRs.MoveNext
loop
Does That make sense?
Another approach is kinda tricky:
create a third recordset in such a way that you could append both header and
detail recordsets to it,
then retrieve header and detail recordsets
append to third recordset and
write it all out in one pass.
Hope that helps
Regards
Habib
Quote:> Hi
> I need to create a fixed length text file with no delimeters. certain rows
of the export have different specifications ie:
Quote:> each row will always be 320 char
> row 1 will be have the first column will be 10 char, the second 30 char
etc.
> row 2 will have the first column of 5 char and the second row 50 char etc
> how can i create an output file with different fixed length columns for
each row?
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
by