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.