A lot of people I have been speaking to recently have asked this and seems to crop up more and more.
i thought it would be useful to build two macros to help solve this challenge.
Using either R or Python the two macros take a feed of files and process them.
If using R, the package used is called 'Officer' which you will need to install separately
For Python, the package used is called 'Docx2txt' , also to be installed seperately
It is a very basic example and there are a whole host of other packages that do something similar.
Here is the R code used:
library(officer)
doc <- read_docx("XXXX")
content <- docx_summary(doc)
head(content)
write.Alteryx(content, 3)
Here is the Python code used:
from ayx import Alteryx
Alteryx.installPackages("docx2txt")
from ayx import Alteryx
import pandas
import docx2txt
text = docx2txt.process('XXXX')
print(text)
#Turn the variabe with html page into Pandas' DF
df = pandas.DataFrame({"text":[text]})
#Write the data frame to Alteryx workflow for downstream processing
Alteryx.write(df,1)
For each method I packaged as a macro, in the code using 'xxxx' as a placeholder for the file name.
Attached is the Workflow+Macros and test file
Enjoy!!
Shaan Mistry
