FUDforum: comp.lang.php » Storing strings and numbers properly in CSV files

Home » Imported messages » comp.lang.php » Storing strings and numbers properly in CSV files

Show: Today's Messages :: Polls :: Message Navigator

Re: Storing strings and numbers properly in CSV files [message #185698 is a reply to message #185620]

Sat, 03 May 2014 00:48

Mr Oldies
Messages: 241
Registered: October 2013

Karma:

Senior Member

On Tue, 22 Apr 2014 11:43:02 -0700 (PDT), sonnichjensen(at)gmail(dot)com wrote:

> Hi
>
> I am saving CSV files from a PHP app, but I face 2 problems:
> 1. stock numbers are sometimes just numbers, but I'd like to keep them as strings
> 2. prices are e.g. 5.2 which Excel translates as a date.
>
> Say:
>
> Item;Name;Price;Amount;Total
> 123;Test;5.2;1;5.2
> 124;Test2;1.2;2;2.4
> Total;;;;=sum(e2:e3)
>
> Just copy this into notepad and save with csv extension and you will see.
>
> I'd like to have 123 and 124 as strings, and eg 5.2 as a float.
> Can I format it better than this?
>
> WBR
> Sonnich

"1","2","3"
Which is a string and which is a constant?
The CSV file does not care.

The application will determine which is which.

Report message to a moderator

[Message index]

		Storing strings and numbers properly in CSV files By: Sonnich Jensen on Tue, 22 April 2014 18:43
		Re: Storing strings and numbers properly in CSV files By: Jerry Stuckle on Tue, 22 April 2014 19:07
		Re: Storing strings and numbers properly in CSV files By: Michael Vilain on Tue, 22 April 2014 19:53
		Re: Storing strings and numbers properly in CSV files By: Christoph Michael Bec on Tue, 22 April 2014 20:29
		Re: Storing strings and numbers properly in CSV files By: Thomas 'PointedEars' on Tue, 22 April 2014 23:27
		Re: Storing strings and numbers properly in CSV files By: Richard Yates on Tue, 22 April 2014 23:24
		Re: Storing strings and numbers properly in CSV files By: Jim Higgins on Thu, 24 April 2014 19:21
		Re: Storing strings and numbers properly in CSV files By: Mr Oldies on Sat, 03 May 2014 00:48

Previous Topic:	Mock HTTP servers for unit tests.
Next Topic:	scandir problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 17:10:11 GMT 2024

Total time taken to generate the page: 0.04628 seconds