Desktop productivity for business analysts and programmers

Importing word document in EG 4.1

Accepted Solution Solved
Reply
Contributor
Posts: 66
Accepted Solution

Importing word document in EG 4.1

Hello,

How can I import a word document in EG 4.1?

The word document is a case study with 172 pages having 20 questions for each member? I would like to save the answers from 172 members. any suggestions?

thanks in advance


Accepted Solutions
Solution
‎09-24-2012 10:41 AM
Valued Guide
Posts: 2,111

Re: Importing word document in EG 4.1

Some suggestions.  There is no magic bullet.

  • you could save the Word document as an XML file and use the XML engine to read it.  If the data are nicely formatted, this may work.
  • you could save the document as text and parse it using the data step.  This involves messy coding, but I have done it successfully.  It is rarely portable.
  • If the answers are in a table in word, you could copy them into Excel and read that.

View solution in original post


All Replies
Solution
‎09-24-2012 10:41 AM
Valued Guide
Posts: 2,111

Re: Importing word document in EG 4.1

Some suggestions.  There is no magic bullet.

  • you could save the Word document as an XML file and use the XML engine to read it.  If the data are nicely formatted, this may work.
  • you could save the document as text and parse it using the data step.  This involves messy coding, but I have done it successfully.  It is rarely portable.
  • If the answers are in a table in word, you could copy them into Excel and read that.
Contributor
Posts: 66

Re: Importing word document in EG 4.1

Thank you very much. I copied all the text and pasted in Excel .

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 130 views
  • 0 likes
  • 2 in conversation