Remove seemingly "empty" rows in Excel Sheet - Containing Spaces

Anna_May1
Anna_May1 New Altair Community Member
edited November 5 in Community Q&A
Hi guys, 

I'm currently cleaning my data and also used an operator to remove missing values. I realized, after writing an excel sheet, that there were still some "empty" cells left. These cells aren't empty though, they are containing a space, thus they seem empty but are really not and Rapidminer won't detect them as such. 

Is there any way to remove rows with one or two spaces in them? As there is text in the other rows I can't just remove all spaces or the text won't make sense anymore. 

Do you guys have a solution for this?

I attached an exemplary file. One of the rows in question would be e.g. row number 138.

Thanks in advance! 

Have a lovely day!
Tagged:

Best Answer

  • kayman
    kayman New Altair Community Member
    Answer ✓
    Use the trim operator, this ensures non text fields are converted to missing (real blank) before export to excel

Answers

  • kayman
    kayman New Altair Community Member
    Answer ✓
    Use the trim operator, this ensures non text fields are converted to missing (real blank) before export to excel
  • Anna_May1
    Anna_May1 New Altair Community Member
    Hey @kayman

    that worked like a charm! Thanks you so much :)


Categories