Hi All

We receive lists of addresses or other groupings of lines of data for things like embroidery. These lists are sometimes submitted in a .doc or .txt file, and they can consist of a mix of 1-6 lines per set. So, we might see a few pages of the following:

Fred Smith
Happy Fred
Summer Camp 2003
...something (Line 4)
...something (Line 5)
...something (Line 6)

(a few returns to separate the next set)

Sue Smith
Happy Sue
Summer Camp 2003
...something (Line 4)
...something (Line 5)

(more returns to go to more sets of lines of data)


What we need is to be able to grab those .doc or .txt lists and have some way of converting them into flatfiles. Each record might also include some fields used for config or setup of our machines. So, you might get:

config_value_1|config_value_2|Fred Smith|Happy Fred|Summer Camp 2003|etc........

Would anyone know of any scripts that can convert those .doc/.txt files into delimited flatfiles?

Many thanks