Reading text based data and getting data types right
Mar 3, 2014 7:37 AM(1434 views)
Hi, apparently simple question, but:
I have set my regional settings to use "." as the decimal separator and "," as the 1000 separator. However being based in Denmark, I should use the opposite. Now, someone generates a data file, that I want to use. Sometimes the file uses ".", sometime it uses "," as the decimal separator.
I want to set an option for the text import filter, that allows me to read the data as numeric regardless of what was chosen by the person who made the file.
So, how do I read data like:
(will be read as characters variables)
with JMP, when the regional settings makes JMP expect numeric data fields to contain the opposite?