"CSV reader, read numbers?"

wessel
wessel New Altair Community Member
edited November 5 in Community Q&A
Dear All,

I have a dataset which sometimes has +numbers.
Like +21.12 or -21.12, or sometimes without, like 21.12.
Do I need to manually delete all the + symbols?
Or is there anyway Rapidminer can read these as normal numbers?

Best regards,

Wessel
Tagged:

Answers

  • B_
    B_ New Altair Community Member
    Use the Replace operator with a regular expression to filter out the +/-.

    B.
  • land
    land New Altair Community Member
    Hi,
    another (possible simple solution) try to define the + as optional part of the separation regular expression.

    Greetings,
     Sebastian