from text to table, with conditions depending on format
Hello, is there anyone willing to help me with this problem?
I have a text formed by several short lines.
Each line start with either one word in italic or two words in italic, non italic words follows.
For example:
word1 word2 Word3 [rest of text]
word4 Word5 [rest of text]
word6 Word7 [rest of text]
What I need to do is to transform this text in a table where
- the first column will always contain the first word
- the second column will either contain the second word in italics, if this is present, or will be empty if a second word in italic is not present
- the third column will always contain the first word not in italic (which can be the second or the third word on the line
I was hoping to do this with a clever combination of find and replace, but I did not succeed.
My knowledge of VBA applied to word is next to zero, so I ask for some assistance.
One idea I had is to select rows starting with only one word in italics, and apply a particular find and replace condition only on those. In this way I think I can correctly place the special characters that I will be use to part the columns of the table.
|