The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
I can't get the
I have an Excel file which has a lot of cells with a lot of text in it. The text in these cells are often separated by an "Alt+Enter", meaning it looks something like this:
First line of text in a cell
Second line of text in a cell
Unfortunately, the "Read Ecxel" operator doesn't read the whole cell. It only reads: "First line of text in a cell" and it ignores the rest of the lines.
I've already tried to wrap the text in Excel with no result.
Is there anyway I can get RapidMiner to read the whole cell?
First line of text in a cell
Second line of text in a cell
Unfortunately, the "Read Ecxel" operator doesn't read the whole cell. It only reads: "First line of text in a cell" and it ignores the rest of the lines.
I've already tried to wrap the text in Excel with no result.
Is there anyway I can get RapidMiner to read the whole cell?
0
Best Answer
-
Prentice Member Posts: 66 MavenAlready got it. It turns out that when it shows the exampleset, it only shows the first line, but the other lines are in there as well. The only thing is, is that it is not displayed in the exampleset0
Answers
Ingo