Return Key

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

Guest

I want to be able Export a record to *txt file and somehow devide it in two
lines at a certain point. Example: record 1 = coffe,sugar,vinegar,candy I
want to place a return key that will brake it for text purposes as
coffe,sugar on one line and vinegar, candy on second line of *txt file
 
How are you doing the export. If you are using the Transfertext method, then
you won't be able to do that without first modifying your records. It will
have to look like two records to the text file. If you are using VBA, you
can put vbCrlf after sugar or the Chr(13) & chr(1) equivilant.
 
This can be done, but you need to be absolutely clear about (a) the
rules that determine where the line break should be inserted, and (b)
whether you want to split this record into two records, or include a
line break within the record, and (c) how text files work in practice.

Normally, a text data file needs to have exactly the same number and
kind of fields on each line, and the only kind of text file that can
normally include line breaks within records is a CSV file.

If you can be more specific we'll be able to point you in the right
direction.
 
Back
Top