Reading numeric data from Excel the decimal separator is here comma "
, ". Since in J the text-to-num-conversion function ". does not
understand comma as decimal separator I must change the commas in the
boxed matrix DATA to dots. I could write a short function:
rplccomma=: 3 : '''.'' (I. y. e. '','')} y.'
and then run
NUM= . ". each rplccomma each DATA.
For large DATA this takes long time to run. Ideas to make this
conversion faster are wellcome. Thanks.
Anssi
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
