In CSV files often we get values like this one
t1=: 0 : 0
123.345.446,45;24.444.67,56;45.444.456,56;90.666.777,45
2;999;1;2
)
_12345 ". ];._2 t1
_12345 _12345
NB. Here I would be expecting
123345446.45 2444467.56 45444456.56 90666777.45
2 999 1 2
NB. quite often CSV files use ; instead of ,
NB. Decorators here in Ísland are . for the thousend and , for the decimals
NB. Excel uses decorations from regional settings
2006/11/6, Anssi Seppälä <[EMAIL PROTECTED]>:
Will there be a day when it is possible modify the operation so that
dots are ignored and commas are respected as decimal delimiters?
Anssi
At 18:20 6.11.2006, you wrote:
>_1234 ". '3,141,592'
>3141592
>
>Commas WITHIN numbers are ignored.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
--
Björn Helgason, Verkfræðingur
Fugl&Fiskur ehf, Þerneyjarsund 23, Box 127
801 Grímsnes ,t-póst: [EMAIL PROTECTED]
Skype: gosiminn, gsm: +3546985532
Landslags og skrúðgarðagerð, gröfuþjónusta
http://groups.google.com/group/J-Programming
Tæknikunnátta höndlar hið flókna, sköpunargáfa er meistari einfaldleikans
góður kennari getur stigið á tær án þess að glansinn fari af skónum
/|_ .-----------------------------------.
,' .\ / | Með léttri lund verður |
,--' _,' | Dagurinn í dag |
/ / | Enn betri en gærdagurinn |
( -. | `-----------------------------------'
| ) | (\_ _/)
(`-. '--.) (='.'=)
`. )----' (")_(")
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
