M
Mike Schelling
I'm starting a new VBA project (actually my first) where I have to pars
information from a Word document and insert it into a database. I'
trying to figure out the best approach to use to identify informatio
in the document. And at the same time trying to keep things use
friendly vice user yukkie for the person sending in the Word document
I plan on having a template that the person uses to build his/her ne
document. The template will ask for name, phone, etc... The part tha
I need a little 'best practices' help with is the variable information
I'm going to as the person to provide information for 'sections' like:
Problem:
Description:
Comments:
The person can repeat the set (e.g., Problem, Description, Comments) a
many times as they want. Within a section can be multiple paragraphs
For example, they could use five paragraphs to explain a problem. And
want to put five paragraphs in a database (memo) field.
I plan on looking through the document for paragraphs beginning wit
"Problem:", "Description:" or "Comments:". I haven't figured out
good way of identify the ending of a section. Here are some thoughts
Do any sound logical? Is there a better way?
1. When I find "Problem:" put everything between it and "Description:
in the memo field. There is going to be a person reviewing the documen
before information is copied to the database. If the next indicator i
not there they can supply it.
2. Or have the user put in starting and ending tags and grab th
information between the tabs
e.g. <problem>blah blah blah</problem>
This is a bit user yukkie.
3. ?????
Any help is more than appreciated.
Mik
information from a Word document and insert it into a database. I'
trying to figure out the best approach to use to identify informatio
in the document. And at the same time trying to keep things use
friendly vice user yukkie for the person sending in the Word document
I plan on having a template that the person uses to build his/her ne
document. The template will ask for name, phone, etc... The part tha
I need a little 'best practices' help with is the variable information
I'm going to as the person to provide information for 'sections' like:
Problem:
Description:
Comments:
The person can repeat the set (e.g., Problem, Description, Comments) a
many times as they want. Within a section can be multiple paragraphs
For example, they could use five paragraphs to explain a problem. And
want to put five paragraphs in a database (memo) field.
I plan on looking through the document for paragraphs beginning wit
"Problem:", "Description:" or "Comments:". I haven't figured out
good way of identify the ending of a section. Here are some thoughts
Do any sound logical? Is there a better way?
1. When I find "Problem:" put everything between it and "Description:
in the memo field. There is going to be a person reviewing the documen
before information is copied to the database. If the next indicator i
not there they can supply it.
2. Or have the user put in starting and ending tags and grab th
information between the tabs
e.g. <problem>blah blah blah</problem>
This is a bit user yukkie.
3. ?????
Any help is more than appreciated.
Mik