Exporting floating numbers to CSV file

Question

3.00/5 (1 vote)

See more:

Hi,

I need to export floating numbers in CSV file with decimal symbol as ",(comma)" in english local settings. I did put that numbers in double quotes in order to prevent my numbers from being formatted before exporting to CSV for example "1,23456789" with the delimiter tab . But when I viewed the file it shows "123,456,789" . Seems like my format has been changed even though i have put in double quotes.

Please give me some suggestion.

I am using cstring to format the float to string. Both in excel and notepad, in both the places it is showing wrong value. Below is my code,

C++

CFileStream _fileLog; 
CString strDelimiter = _T("\t"); 
CString strQuote = _T("\""); 
CString strContent; 
strContent = strQuote + _T("1,23456789") + strQuote + strDelimiter + 
             strQuote + _T("9,12345678") + strQuote;
fileLog.Write(strContent);

Posted 19-Oct-11 1:29am

bunathangaraj

Updated 19-Oct-11 23:01pm

Stefan_Lang

v2

Add a Solution

Comments

Maximilien 19-Oct-11 7:36am

Show us the code you use to write to the file (ONLY the few lines that format and write the float values).
Are you using STL (stream) or sprintf to format the float to the string ?
How are you viewing the result ? in notepad or in excel (for example) ?

bunathangaraj 19-Oct-11 7:48am

I am using cstring to format the float to string. Both in excel and notepad, in both the places it is showing wrong value.
Below is my code,
CFileStream _fileLog;
CString strDelimiter = _T("\t");
CString strQuote = _T("\"");
CString strContent;
strContent = strQuote + _T("1,23456789") + strQuote + strDelimiter + strQuote + _T("9,12345678") + strQuote;
_fileLog.Write(strContent);

str.Replace(_T("."), _T(","));

Chuck O'Toole 19-Oct-11 21:43pm

Impossible! Everything in this code is a string and all you are writing is one big string. There is no way that just reading it with notepad is going to apply a "comma every 3 digits" type interpretation. You are looking in the wrong place for the file this creates.

bunathangaraj 19-Oct-11 7:49am

pls ignore the last line in the above code

Richard MacCutchan 19-Oct-11 9:25am

What are you using to view the file? If you are using Excel and the system decimal separator is "." then Excel will not recognise your values as floating point, but as integers.

bunathangaraj 19-Oct-11 9:44am

Excel only.. no solution for this? Can't i change this format as text and store?

Maximilien 19-Oct-11 10:51am

open the file in notepad and check it out.

bunathangaraj 19-Oct-11 10:55am

In notepad also same problem, I have stored in CSV like "1,23456789" and when i opened in notepad it shows "123,456,789"

Stefan_Lang 20-Oct-11 5:04am

1. When you have additional information to your original qustion, do enter it into your original posting, by using the link 'Improve question'. I did that for you just now, but please remember for the future.
2. When you respond to another persons comment, use the 'Reply' link at the top right of that comment! Otherwise that person will not be notified of your response and may not be aware you answered! All your responses above are just comments to your own posting, and none of the previous posters will be aware of that unless they thought to check on your question again.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Stefan_Lang · Answer 1 · 2011-10-19T23:07:00

Solution 2

Your code is missing a statement to open the file! You are not writing anything that way. Whatever file you look at, it will never change.

Posted 19-Oct-11 23:07pm

Stefan_Lang

Comments

Chuck O'Toole 20-Oct-11 9:10am

Nice catch, I didn't see that when I told him he was looking in the wrong place for the file. There is no file (nor spoon) +5

enhzflep · Answer 2 · 2011-10-19T14:10:00

Don't know that this will help...
Guess you'll have to look deeper into CFile and/or CString

Code

C++

#include <iostream>
#include <fstream>
using namespace std;

int main () {

  fstream filestr;
  string delim = "\t", quotes = "\"", content;

  filestr.open ("test.txt", fstream::in | fstream::out | fstream::app);

  content = quotes + "1,23456789" + quotes + delim;
  content += quotes + "9,12345678" + quotes + delim;

  filestr << content;

  filestr.close();

  return 0;
}

Output

"1,23456789"    "9,12345678"