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 #185624 is a reply to message #185620]

Tue, 22 April 2014 19:53

Michael Vilain
Messages: 88
Registered: September 2010

Karma:

Member

In article <92e0366c-bb9b-48cc-b239-d90f14865c8a(at)googlegroups(dot)com>,
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

The quoting rules with CSV must be somewhere on the web. Try googling
it. It should explain when you have to put entries in quotes. If all
else fails, just quote everything.

--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically ignored]

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: Fri Nov 22 04:33:11 GMT 2024

Total time taken to generate the page: 0.04599 seconds