Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Word Document Addresses into Excel List

vandecx17
5 - Atom

I have a Word document with addresses that I need to get into a list to compare to another word document with addresses. Is there a way to get this into a list (with separate columns for "Name" and "Address") without going one by one?

1 REPLY 1
clmc9601
13 - Pulsar
13 - Pulsar

Hi @vandecx17,

 

Yes, but it depends on your formatting. Alteryx finds it easier to parse .txt files over .doc files, so I'd recommend copy and pasting your document into Notepad and saving it as a text file first. I've included examples of parsing .doc and .txt files both, but the .txt is more dynamic. The configurations will clear if you change it to your own files, so be sure to take note of the set configurations on the Input tools first!

 

Screen Shot 2021-12-06 at 11.31.08 PM.png

 

If this helps, please consider marking it as a solution so others may find it.

 

Labels