Hello everyone,
I am a college student from Germany working on my Master's thesis. I am working on Machine Learning approaches that need annotated sentences. These sentences are available to me in the form of .csv files that can be read by Excel (my version is OSX 2011). My problem is the following:
Table definition:
ID_A | ID_B | Description | Label_{A, ... , Z}
Description is a single text that has been produces by a piece sentence splitting code. Each sentence can be annotated with SEVERAL different labels. This is because different parts of a sentence can describe different labels. Consider: "This is a good book, but the characters are very weak."
"This is a good book" would receive a different label than "but the characters are very weak."
Now, I need a macro command, that splits such a sentence. The best way (for a number of reasons) would be to put the cursor inside that cell and split the Description text at that cursor. Copy the cut off part into a new line below and copy every OTHER cell of the original one into the newly created as well.
I am fairly accomplished with a large number of programming languages, Visual Basic is not one of them. I would be very grateful for some specific advice, maybe relatable code that I can work on or information of such nature.
Best of thanks
Apophis
Bookmarks