Hi, I get from our survey Tool Focus Vision Decipher data files .sav which I open in JMP. Unfortunately Umlaute are not displayed on the right way. Can anyone can give me an add-in for replacing these (see attached file) or an idea what to do.
SPSS import in JMP currently only supports ASCII character data. We hope to support UTF-8 encoding SAV files in the future. If your SAV file is UTF-8 and you would be willing to share it with JMP Tech Support (firstname.lastname@example.org), it would be helpful in the development of this feature.
I'm sorry, I don't have a script to convert the characters, although I think it would be possible.
for the sake being, this script might help:
Names Default To Here( 1 ); //dt = Open("problem_mit_umlauten"); dt = Current Data Table(); nr = nrows(dt); col_names = dt << Get Selected Columns (String);// get column names (String); for (i = 1, i <= nitems(col_names), i++, one_col = column(dt, col_names[i]); for (k = 1, k <= nr, k++, one_col[k] = substitute(one_col[k], "Ã¤", "ä"); // Replace to ä one_col[k] = substitute(one_col[k], "Ã¼", "ü"); // Replace to ü ); colName = substitute(col_names[i], "Ã¤", "ä"); // ColName Replace to ä colName = substitute(colName, "Ã¼", "ü"); // ColName Replace to ü column(dt, col_names[i]) << Set Name(colName); // Rename Column );
It takes the selected (character) columns of your current data table and substitutes the bad interpretation with Umlaute. The for loop looks into every row of the selected column, after the for loop it also checks the column name.
In your case there are just two variations of misinterpretated umlauts, more you can add in a similar fashion.
Adding this script into your Menu as a menu item can ease your life (need not to search for the script again and again :) )
Hope this helps.