Options

"CSV reader, read numbers?"

wesselwessel Member Posts: 537 Maven
edited May 2019 in Help
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

  • Options
    B_B_ Member Posts: 70 Maven
    Use the Replace operator with a regular expression to filter out the +/-.

    B.
  • Options
    landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    Hi,
    another (possible simple solution) try to define the + as optional part of the separation regular expression.

    Greetings,
     Sebastian
Sign In or Register to comment.