Results 1 to 5 of 5
  1. #1
    Newbie
    Join Date
    January 18th, 2005
    Posts
    23
    Hi everyone,

    I am using OpenOffice to clean up a csv datafeed. So far so good, but every time I save it in csv, I loose the 0 and 00 decimals in the price column.
    So $ 15.00 wends up being saved as $ 15 and $ 15.50 as $ 15.5.

    Any suggestions on how to get around this?

    Thanks,

    Peete

  2. #2
    Devil's Reject Electropulse's Avatar
    Join Date
    January 18th, 2005
    Posts
    987
    go to [format] Cells>

    and under the [Numbers] tab with the heading [Category] highlight [Currency] and choose -$1,234.00

  3. #3
    Newbie
    Join Date
    January 18th, 2005
    Posts
    23
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by electricpixel:
    go to [format] Cells&gt;

    and under the [Numbers] tab with the heading [Category] highlight [Currency] and choose -$1,234.00 <HR></BLOCKQUOTE>

    Hi electricpixel,

    That works okay, but as soon as I save as csv/txt the currency formatting disappears.
    Is there anything special involved with saving the file?

    Thanks,

    Peete

  4. #4
    Full Member
    Join Date
    January 18th, 2005
    Posts
    284
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Peete:


    Hi electricpixel,

    That works okay, but as soon as I save as csv/txt the currency formatting disappears.
    Is there anything special involved with saving the file?

    Thanks,

    Peete <HR></BLOCKQUOTE>

    Nope - once you save as CSV all special formating is lost.
    CharPaula
    Staying focused on the bottomline

  5. #5
    Member
    Join Date
    January 18th, 2005
    Posts
    145
    This is one of the reasons I use a text editor to edit feeds, Excel can have the same quirk with saving the formatting, I've noticed that with some feeds which use quotation marks around the values, that Excel strips the quotation marks, UNLESS there is a , in the values.

    Using a text editor with macroing, and a robust search and replace feature doesn't edit the actual datafeed in any unexpected ways.

    Depending on what language you're using, you could make the variables for the price back to two places with either the old multiply by 100, integer, divide by 100 trick; or by formatting the variables in the script.

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. PriceAngels.com can't get decimals correct for sales?
    By RacerX in forum ShareASale - SAS
    Replies: 3
    Last Post: July 27th, 2011, 06:50 AM
  2. OpenOffice DBase
    By country in forum WebMerge (Fourthworld.com)
    Replies: 8
    Last Post: March 14th, 2008, 02:32 PM
  3. OpenOffice
    By Kevin in forum Midnight Cafe'
    Replies: 18
    Last Post: November 12th, 2005, 02:20 PM
  4. does webmerge work with OpenOffice?
    By Electropulse in forum WebMerge (Fourthworld.com)
    Replies: 2
    Last Post: March 23rd, 2003, 01:35 PM
  5. Displaying decimals
    By popdawg in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: August 25th, 2002, 10:13 AM

Posting Permissions

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