Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: TransferText Question

    Hey All,

    Does anyone know if I can use a new line as the delimeter when I export a table as a text file? If so how can I do this?


  2. #2
    Join Date
    Feb 2003
    San Antonio, TX

    New Line as a delimiter

    I would not recommend using a NewLine character as a delimiter in expeorting data as a text file. The result will be that you will have exported each field as a separate line and, unless you know some sort of magic trick, importing the data wil result in each field being considered a new record and you will have no way of knowing when the original first record ends and the original second record begins.

    What is wrong with using either tab-delimited or "comma-quote" delimited output? or, if you don't want the qoutes and yet have either tabs or commas in your data (or both) then you might try changing the delimiter to "|".
    Ralph D. Wilson II

    "Any sufficiently advanced technology is indistinguishable from magic." A.C. Clark

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts