cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Substitute_Decimal2Comma

Should be used when display language setting is GERMAN and the import has brought in numeric data as character due to the decimal point. This script converts values with decimal seperator to comma seperator and changes the data type to continuous.

 

THIS SCRIPT WILL NOT WORK FOR ENGLISH LANGUAGE SETTING

 You will find the script to convert in the other direction commented or under this script in file exchange ("Substitute_Comma2Decimal.jsl")

 

There are three files:

  • "HowTo" document "Decimal2Comma.doc"
  • The script file itself "Substitute_Decimal2Comma.jsl"
  • Example Data Table to be used to test the script "Decimal_Comma.jmp"

You might change the script to fullfill your language needs. However it should work also for FRENCH and other languages supporting comma separated floating point numbers.

 

 

Comments

Awesome.  exactly what I was looking for :)  Nice and elegant script.

Thanks, glad it is helpful :)

Update: By the way, as of JMP 15 the RECODE functionality has a new formula generation functionality which is not using a match statement. This allows to use some code like this as base for the transition:

Recode( :Column 6, {Substitute( _rcNow, ".", "," ), Num( _rcNow )} )

or:

Num( Recode( :Column 6, {Substitute( _rcNow, ".", "," )} ) )

Finally you still have to set the modeling type to continuous.

 

Just if you were not aware of it :)