+ Reply to Thread
Results 1 to 3 of 3

why are there quotes in my exported text file?

Hybrid View

  1. #1
    AlexK
    Guest

    why are there quotes in my exported text file?

    I saved an Excle file containing text into a tab delimeted text file and all
    the data is now in quotes. The file will be used as a input file to another
    progarm and the quotes will not be accepted. How can the quotes be left off?

  2. #2
    Gordon
    Guest

    Re: why are there quotes in my exported text file?

    AlexK wrote:
    > I saved an Excle file containing text into a tab delimeted text file and all
    > the data is now in quotes. The file will be used as a input file to another
    > progarm and the quotes will not be accepted. How can the quotes be left off?


    Find and Replace. Find " and replace with - nothing!

    --
    Interim Systems and Management Accounting
    Gordon Burgess-Parker
    Director
    www.gbpcomputing.co.uk

  3. #3
    CyberTaz
    Guest

    RE: why are there quotes in my exported text file?

    Hey Alex-

    The Quotation Marks are used in data transfer as what are called Qualifiers.
    They are used by the receiving program to distinguish between fields
    containing TEXT as opposed to VALUES. If that program is a data management
    program, the Quotes do not show up as field content, they just help that
    program identify what type of data it is. In this case the Quotes should be
    there.

    If the program that will use the data is not a data management application
    or cannot accept the file as-is, it might be best to Save As again using a
    File Type that is compatible with the other program. Just stripping out the
    quotes could cause other problems on the receiving end.

    Hope this is useful |:>)

    "AlexK" wrote:

    > I saved an Excle file containing text into a tab delimeted text file and all
    > the data is now in quotes. The file will be used as a input file to another
    > progarm and the quotes will not be accepted. How can the quotes be left off?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1