Exporting Wraping Data to Flat File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a two fields that I need to export to a flat file. First one is a Date field [NtDate] in "yyyy/mm/dd" format. The second is a text field [Note] 200 character's in length. The file format is, NtDate in positions 1 to 10, Note in positions 11 to 50.

The Note field needs wrap to the next line, but each line has to start with the Date. Any Ideas???
 
You could build a report and in the detail section put

Left([FieldName],10) Mid([FieldName],11,20)
Left([FieldName],10) Mid([FieldName],31,20)


Or something like that. I'm not sure if my 'mid' syntax is correct. I
don't use that function often and figure you can look at the help fiel as
easily as I can.

If you are exporting it to excel, it would be easy to build some functions
to fill in the blank with the date from the previous line.


Rick B


"(e-mail address removed)"
I have a two fields that I need to export to a flat file. First one is a
Date field [NtDate] in "yyyy/mm/dd" format. The second is a text field
[Note] 200 character's in length. The file format is, NtDate in positions 1
to 10, Note in positions 11 to 50.

The Note field needs wrap to the next line, but each line has to start with
the Date. Any Ideas???
 
Yes but that would then leave the issue of formating the note field for each Mid Statement to prevent cutting words in halph. Any other Ideas?

Thanks for the Help.
rjerskine
 
Back
Top