Re: [BLACKBOX] Regional numbers (was 1.6 final)

From: [at]} <Chris>
Date: Wed, 8 Jul 2009 09:31:31 +0930

----boundary-LibPST-iamunique-378152795_-_-
Content-type: text/plain

>-----Original Message-----
>From: BlackBox [mailto:BLACKBOX{([at]})nowhere.xy
>Rex Couture
>Sent: Wednesday, 8 July 2009 2:15 AM
>To: BLACKBOX{([at]})nowhere.xy
>Subject: Re: [BLACKBOX] Regional numbers (was 1.6 final)
>
>At 02:23 AM 7/7/2009, Robert Campbell wrote:
>>>> > At 03:45 AM 7/4/2009, Detlef.Jankowiak-Evers wrote:
>>>> >>Dear Marc, dear All,
>>>> >>
>>>> >>one thing I'm missing all the time is to be able to type
>>>> in numbers in
>>>> >>german style (, as decimal point ).
>>
>>
>>Are you concerned only about the user GUI on forms, or also
>about ascii
>>in Texts and Files?
>
> Indeed, a comma is usually a separator in text and
>files. I suspect it becomes a problem if you use it as a
>decimal point.
>

If you are referring to the use of a comma in comma-separated-value (CSV)
formatted files then it is not an issue. The usual solution is to use quotes
to distinguish between the data fields and the comma separators

e.g. "1.120,0", "1.130,1", "1.140,2"

using the German formatting style.

One non-German style format often used already has a comma as a 'thousands'
separator anyway:

 1,120.0
 1,130.1
 1,140.2

Also, this is no different to the problem that occurs if you are using a CSV
file which has string data which includes commas:

e.g. "10, Downing Street", "221b, Baker Street", "23, Osborne Drive"

However, you then have to deal with embedded quotes in strings. For this
reason I prefer to use tab-separated-value (TSV) files when using text files
to represent tables of data.

Regards,
Chris Burrows

CFB Software
Armaide v2.0: ARM Oberon-07 Development System
http://www.cfbsoftware.com/armaide

----
To unsubscribe, send a message with body "SIGNOFF BLACKBOX" to LISTSERV{([at]})nowhere.xy----boundary-LibPST-iamunique-378152795_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"
e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwID4tLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLVxw
YXINCj5Gcm9tOiBCbGFja0JveCBbbWFpbHRvOkJMQUNLQk9YQExJU1RTLk9CRVJPTi5DSF0gT24g
QmVoYWxmIE9mIFxwYXINCj5SZXggQ291dHVyZVxwYXINCj5TZW50OiBXZWRuZXNkYXksIDggSnVs
eSAyMDA5IDI6MTUgQU1ccGFyDQo+VG86IEJMQUNLQk9YQExJU1RTLk9CRVJPTi5DSFxwYXINCj5T
dWJqZWN0OiBSZTogW0JMQUNLQk9YXSBSZWdpb25hbCBudW1iZXJzICh3YXMgMS42IGZpbmFsKVxw
YXINCj5ccGFyDQo+QXQgMDI6MjMgQU0gNy83LzIwMDksIFJvYmVydCBDYW1wYmVsbCB3cm90ZTpc
cGFyDQo+Pj4+ID4gQXQgMDM6NDUgQU0gNy80LzIwMDksIERldGxlZi5KYW5rb3dpYWstRXZlcnMg
d3JvdGU6XHBhcg0KPj4+PiA+PkRlYXIgTWFyYywgZGVhciBBbGwsXHBhcg0KPj4+PiA+PlxwYXIN
Cj4+Pj4gPj5vbmUgdGhpbmcgSSdtIG1pc3NpbmcgYWxsIHRoZSB0aW1lIGlzIHRvIGJlIGFibGUg
dG8gdHlwZVxwYXINCj4+Pj4gaW4gbnVtYmVycyBpblxwYXINCj4+Pj4gPj5nZXJtYW4gc3R5bGUg
KCwgYXMgZGVjaW1hbCBwb2ludCApLlxwYXINCj4+XHBhcg0KPj5ccGFyDQo+PkFyZSB5b3UgY29u
Y2VybmVkIG9ubHkgYWJvdXQgdGhlIHVzZXIgR1VJIG9uIGZvcm1zLCBvciBhbHNvIFxwYXINCj5h
Ym91dCBhc2NpaSBccGFyDQo+PmluIFRleHRzIGFuZCBGaWxlcz9ccGFyDQo+XHBhcg0KPiAgICAg
ICAgSW5kZWVkLCBhIGNvbW1hIGlzIHVzdWFsbHkgYSBzZXBhcmF0b3IgaW4gdGV4dCBhbmQgXHBh
cg0KPmZpbGVzLiAgSSBzdXNwZWN0IGl0IGJlY29tZXMgYSBwcm9ibGVtIGlmIHlvdSB1c2UgaXQg
YXMgYSBccGFyDQo+ZGVjaW1hbCBwb2ludC5ccGFyDQo+XHBhcg0KXHBhcg0KSWYgeW91IGFyZSBy
ZWZlcnJpbmcgdG8gdGhlIHVzZSBvZiBhIGNvbW1hIGluIGNvbW1hLXNlcGFyYXRlZC12YWx1ZSAo
Q1NWKVxwYXINCmZvcm1hdHRlZCBmaWxlcyB0aGVuIGl0IGlzIG5vdCBhbiBpc3N1ZS4gVGhlIHVz
dWFsIHNvbHV0aW9uIGlzIHRvIHVzZSBxdW90ZXNccGFyDQp0byBkaXN0aW5ndWlzaCBiZXR3ZWVu
IHRoZSBkYXRhIGZpZWxkcyBhbmQgdGhlIGNvbW1hIHNlcGFyYXRvcnNccGFyDQpccGFyDQplLmcu
ICIxLjEyMCwwIiwgIjEuMTMwLDEiLCAiMS4xNDAsMiJccGFyDQpccGFyDQp1c2luZyB0aGUgR2Vy
bWFuIGZvcm1hdHRpbmcgc3R5bGUuIFxwYXINClxwYXINCk9uZSBub24tR2VybWFuIHN0eWxlIGZv
cm1hdCBvZnRlbiB1c2VkIGFscmVhZHkgaGFzIGEgY29tbWEgYXMgYSAndGhvdXNhbmRzJ1xwYXIN
CnNlcGFyYXRvciBhbnl3YXk6XHBhcg0KXHBhcg0KIDEsMTIwLjBccGFyDQogMSwxMzAuMVxwYXIN
CiAxLDE0MC4yIFxwYXINClxwYXINCkFsc28sIHRoaXMgaXMgbm8gZGlmZmVyZW50IHRvIHRoZSBw
cm9ibGVtIHRoYXQgb2NjdXJzIGlmIHlvdSBhcmUgdXNpbmcgYSBDU1ZccGFyDQpmaWxlIHdoaWNo
IGhhcyBzdHJpbmcgZGF0YSB3aGljaCBpbmNsdWRlcyBjb21tYXM6XHBhcg0KXHBhcg0KZS5nLiAi
MTAsIERvd25pbmcgU3RyZWV0IiwgIjIyMWIsIEJha2VyIFN0cmVldCIsICIyMywgT3Nib3JuZSBE
cml2ZSJccGFyDQpccGFyDQpIb3dldmVyLCB5b3UgdGhlbiBoYXZlIHRvIGRlYWwgd2l0aCBlbWJl
ZGRlZCBxdW90ZXMgaW4gc3RyaW5ncy4gRm9yIHRoaXNccGFyDQpyZWFzb24gSSBwcmVmZXIgdG8g
dXNlIHRhYi1zZXBhcmF0ZWQtdmFsdWUgKFRTVikgZmlsZXMgd2hlbiB1c2luZyB0ZXh0IGZpbGVz
XHBhcg0KdG8gcmVwcmVzZW50IHRhYmxlcyBvZiBkYXRhLlxwYXINClxwYXINClJlZ2FyZHMsXHBh
cg0KQ2hyaXMgQnVycm93c1xwYXINClxwYXINCkNGQiBTb2Z0d2FyZVxwYXINCkFybWFpZGUgdjIu
MDogQVJNIE9iZXJvbi0wNyBEZXZlbG9wbWVudCBTeXN0ZW1ccGFyDQpodHRwOi8vd3d3LmNmYnNv
ZnR3YXJlLmNvbS9hcm1haWRlXHBhcg0KXHBhcg0KXHBhcg0KLS0tLVxwYXINClRvIHVuc3Vic2Ny
aWJlLCBzZW5kIGEgbWVzc2FnZSB3aXRoIGJvZHkgIlNJR05PRkYgQkxBQ0tCT1giIHRvIExJU1RT
RVJWQExJU1RTLk9CRVJPTi5DSFx9fQByZS4=
----boundary-LibPST-iamunique-378152795_-_---

Received on Wed Jul 08 2009 - 02:01:31 UTC