Excel String to Numerical in RM?

mortizmortiz Member Posts: 20 Maven
edited August 2019 in Help
I have imported a bunch of numerical data from excel into RM, but some cells have text, so RM converts all the attributes to a polynominal. However, I want everything to be converted to the value indicated in the string. The only way I know to do this is go into the Data Editor and click on each attribute to make it into a real, however I have 200 attributes and this would be tedious to do everytime.

Lastly, how do I filter out all cells in each attribute that has text in it? I can't seem to get the filter expression syntax correct.

Any help would be great! thank you.

Best Answer


  • Options
    varunm1varunm1 Moderator, Member Posts: 1,207 Unicorn
    Hello @mortiz

    If you want to convert all the attributes to numerical and if every attribute is a nominal you can use (nominal to numerical operator). You can also change it using Turbo prep.

    Hope this helps. If you need more information please inform.

    Be Safe. Follow precautions and Maintain Social Distancing

  • Options
    mortizmortiz Member Posts: 20 Maven
    This is helpful. thank you!
  • Options
    mortizmortiz Member Posts: 20 Maven
    Selecting the Operator Parse Numbers and setting the option Parameter "Unparsable value handling":  "replace with missing values" absolutely did the trick! thank you.
Sign In or Register to comment.