A=:".rplccomma,' ',"1>DATA NB. But you are limited on the size of DATA and 
homogeneity... You might have to partition in large chunks before


Paul Gauthier
APL Software Developer - Senior
[EMAIL PROTECTED]
Phone: 312-739-3467
Fax: 312-739-3496

CheckFree. The Company that Powers Payment on the WebSM.
http://www.checkfree.com/paybillsonline




Anssi Seppälä <[EMAIL PROTECTED]> 
Sent by: [EMAIL PROTECTED]
03/02/2006 03:59 AM
Please respond to
Programming forum <[email protected]>


To
Programming forum <[email protected]>
cc

Subject
[Jprogramming] Faster way to replace commas in boxed data






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

----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to