|
|
View previous topic :: View next topic |
Author |
Message |
dynamitron
Joined: 18 Mar 2009 Posts: 38
|
how to change , into . |
Posted: Tue May 08, 2012 3:07 pm |
|
|
I have a code which write a string to a SD card. The file on the SD card has the extension .csv to be easily readable by excel
Before to write I use "sprintf" to convert numerical data into char.
My question : I want that the conversion of the temperature [0] from float to string generates a "," in place of a "." for the decimal separator.
how is it possible to do that ?
Thanks for the answers
Code: | sprintf(line,"%02u:%02u:%02u %02u/%02u/%02u %6.2f\r\n",heure, Minute,Seconde,day,month,year,temperature [0]);
write_sd(file_name,line); |
|
|
|
temtronic
Joined: 01 Jul 2010 Posts: 9219 Location: Greensville,Ontario
|
|
Posted: Tue May 08, 2012 3:21 pm |
|
|
If I understand it right..
you want to convert 1.234 to 1,234
Easy enough to do a simple if comma then replace with period function but...
The problem I see is that when you import into say Excel as a dotCSV file, Excel will split the temperature reading 1,234 into two ( 1 and 234).
Is this what you really want ?
Perhaps an example or two would be helpful. |
|
|
dynamitron
Joined: 18 Mar 2009 Posts: 38
|
|
Posted: Tue May 08, 2012 3:39 pm |
|
|
For example the value of the float is 21.21
If I use the above code, after the sprintf, I find 21.21 in the result but I would like to have 21,21 |
|
|
PCM programmer
Joined: 06 Sep 2003 Posts: 21708
|
|
Posted: Tue May 08, 2012 4:16 pm |
|
|
He wants European notation for the decimal point. |
|
|
temtronic
Joined: 01 Jul 2010 Posts: 9219 Location: Greensville,Ontario
|
|
Posted: Tue May 08, 2012 5:44 pm |
|
|
Yeah, but that'll get messed up when imported as a Comma Separated Variable file unless he can use a different separater than a comma.
I don't use Excel to often though I am real familiar with Visicalc. |
|
|
jeremiah
Joined: 20 Jul 2010 Posts: 1343
|
|
Posted: Tue May 08, 2012 5:58 pm |
|
|
I thought that if you encase it in quotes that it retains the comma? It's been a while with csv format files. |
|
|
asmboy
Joined: 20 Nov 2007 Posts: 2128 Location: albany ny
|
|
Posted: Tue May 08, 2012 6:33 pm |
|
|
actually its EZ
LET the float be formatted with the decimal point
excel has the OPTION after importing the .CSV data
to change the representation format
inside the spreadsheet is the place to do it...... |
|
|
Mike Walne
Joined: 19 Feb 2004 Posts: 1785 Location: Boston Spa UK
|
|
Posted: Wed May 09, 2012 1:50 am |
|
|
OK. So let Excel do the donkey work.
If he really HAS to convert to using a comma there's no problem importing into Excel, since there's an option to change the separator to semicolon, tab and/or any other character.
Mike |
|
|
Ttelmah
Joined: 11 Mar 2010 Posts: 19482
|
|
Posted: Wed May 09, 2012 2:21 am |
|
|
Yes. This is very much related to the problem another user was having a while back, where 123,45 inside a command, was returning '45'. In C itself, the decimal separator _must_ be '.'.
The key is to read up on CSV. In CSV files, there are two possible legal 'cell' separators. The ',', and the ';'. (Many programs allow others, but these are the defined ones) In the CSV definitions, _if_ your country locale uses ',' as the decimal separator, then you are meant to use ';' as the cell separator. Using double inverted commas round the numbers (effectively outputting then as strings), sometimes works, but can also give problems with some applications. Quite a few programs take the 'CSV is a separate standard' approach, and whatever the local decimal separator, use '.' inside the CSV file, and convert to the local standard when this is read. Personally this seems to give less problems...
So, if you want to be compatible with other programs, the 'safest' approach seems to be to always use . as the decimal separator.
Alternatively, use ',', and switch to using ';' as the cell separator. In the code you post, you are using ':' as the separator, and quite a few programs won't support this.
If you must output using the comma, then use sprintf, to put the number into a text string, and then use:
Code: |
char buffer[20]; //long enough for your number
float float_val=123.456;
sprintf(buffer,"%3.4f",float_val);
*(char *)(strchr(buffer,'.'))=',';
|
This then gives you the string 123,456 in 'buffer', available to be printed to your output. The cast to 'char *', is not really necessary, but ensures it works with all CCS versions.
Best Wishes |
|
|
dynamitron
Joined: 18 Mar 2009 Posts: 38
|
|
Posted: Wed May 09, 2012 4:48 am |
|
|
Thank you all, I will use your answers to find the easiest solution for me. |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|