[Year 12 SofDev] Data dictionary - data formats

[Andrew Shortell]

Hi Mike
Most "people" would merge it out from an excel file into say an address
label
Would microprice s/w print the leading zero when it comes from excel as a
number?
Would any other better written s/w print the leading zero?

Would it not be simpler to just treat it as text ...


You no doubt will remember when NT postcodes changed.. (It was when Oz post
wanted to introduce personalised postcodes for big companies in sydney and
melb - melb got the 8000s and sydeny got the 9000s) this occurred after ram
/hdd space became significantly cheaper and thus within the price point of a
public provider of services such as oz post

So originally they were all numeric which would have fitted with the whole
thought that they could be stored in less space... Now that restriction is
functionally irrelevant.

Andrew S
-- 
Andrew Shortell
Hoping to be able to save enough to become semi retired in my mid to late
60s (did some one think Jealous? )

mailto:shortell at get2me.net
Heidelberg Teaching Unit
Ph 9470 3403
Fax  9470 3215




On 6/04/11 4:19 PM, "Mike Brookes" <mikebr at tpg.com.au> wrote:

> Actually you can :-)
> The output just needs to be formatted as 4 digits (in microsloth speak
> use a custom format of 0000)
> 
> Mike Brookes
> Semi retired gentleman from Copperfield College
> 
> On 6/04/2011 2:14 PM, Andrew Shortell wrote:
>> Hi Gordon
>> Just by the way  - northern territory postcodes start with a zero .. Thus
>> cannot store postcode as number
>> 
>> Andrew
>> 
>> Andrew Shortell
>> 
>> mailto:shortell at get2me.net
>> Heidelberg Teaching Unit
>> Ph 9470 3403
>> Fax  9470 3215
> 
> _______________________________________________
> http://www.edulists.com.au - FAQ, Subscribe, Unsubscribe
> IT Software Development Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel3-4.html
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers
> Association Inc

--