View Single Post
 
Old 10-29-2015, 08:35 AM
Marco Marco is offline Windows Vista Office 2007
Novice
 
Join Date: Apr 2015
Posts: 15
Marco is on a distinguished road
Default 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.
Reply With Quote