Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2005
    Posts
    39

    Unanswered: Export to text tab delimited file

    Hi
    I am trying to export to a text tab delimited file. That is all fine, but I have a problem with one column. It is a column containing numbers. In the text file it shows it as a number with 2 decimals. I want to have zero decimals. I tried to manipulate the query with round function but that does not work. In the export specification I cannot change it somehow. Any ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    When you say it didn't work do you mean you couldn't get round to work in the query or it wouldn't export properly?

    Anyway - try using the Fixed format, 0 decimal places properties of the column or try the following function (also avoids the semi-arbitary rounding of .5 of the round function as a handy extra):
    Code:
     CINT([MyColWithDecs] + 0.5) AS MyColWithoutDecs
    Also, unless absolutely necessary I would always advise exporting and storing unrounded numbers - rounding should be considered a presentation issue really. Depends on your reuirement of course.

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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