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

Answers

  • 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.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

  • mortizmortiz Member Posts: 20 Maven
    This is helpful. thank you!
  • 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.