Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    11

    Unanswered: Export Has Weird Characters For Numeric Fields

    Hello,
    I'm getting weird characters returned for numberic fields.

    Current Format
    +000000000000001.2485

    Expected Format
    1.2485

    Below is the export command I'm using. Can someone advise on how to format numeric fields correctly?

    export to c:\test\txn2011.txt of del modified by COLDEL0x09 NOCHARDEL SELECT Partner, Profit FROM SchoolBudget;

  2. #2
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    that is the correct format. If you'd like it in a different format, you would have to change the data type on the select statement. Something like:

    SELECT Partner, strip(digits(Profit),l,'0') FROM SchoolBudget

    Dave

Posting Permissions

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