Text is truncated when importing.

Question

I converted a word document to txt and upload the txt file to alteryx. It seems some cells that has long texts gets truncated(it is complete in txt file).

I tried to remove delimiters and increase the field length. It is still truncated. Any idea how to fix? Thanks!

AmeliaG · Accepted Answer

@chritinepwc

Thanks for your question! Instead of using no delimiter '\0', I would try using a new line delimiter '
'. Lett me know if this helps. If no, have you tried using the 3rd party tool to parse word docs? The latter approach is detailed here.

If neither of these solutions work, let me know and I'd be happy to dig in further.

Have a great day!

Amelia