I converted word document into txt file using this method
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Can-Alteryx-Parse-A-Word-Doc-Or-PDF/ta-p/1156
When the txt file is loaded into alteryx, some of the characters are not being recognized.
E.g. (comma only for separation)
-, ", ..., '
Those appears in Alteryx as 'â'€. I can easily replace that but the issue I have is that there is no way of knowing which is which as all of the above characters are replaced by –.
I import the txt file as CSV with \0 as delimiter.
Example
In txt file - “ Account Type – PAT status, Channel & HQ area:
In alteryx - Account Type – PAT status, Channel & HQ area:
in txt file - The non-highlighted fields on the form (indicated with ‘click to enter text)
in alteryx - The non-highlighted fields on the form (indicated with ‘click to enter text)
in txt file - Defend – Key Actions
in alteryx Defend – Key Actions
and so on.
Ideally, I would like the txt file to be loaded in a way that all of those characters are being recognized.
Solved! Go to Solution.
Works perfectly, thank you!