Importing RTF file

[PaulJasonMackjoo]

Hi all,

I have tried to input a RTF file on Alteryx but the data got messy. I am wondering if there is a particular way to import it as clean as possible.

Attached is a sample of the file. I do not know though if the tests are representative.

Kind regards,

Paul

[Yoshiro_Fujimori]

@PaulJasonMackjoo ,

Unlike HTML, RTF code is not easy to read.

I cannot find Alteryx tools which deal with RTF directly.

So it would not be easy to develop a workflow by yourself using Formula or RegEx tools.

However, there is a python package "striprtf" which convert rtf files to strings.

If you are familiar with Python, you may want to use import this package in your Python tool on Alteryx.

If you are not, maybe it would be better to convert RTF to TXT outside of Alteryx (e.g. using MS Word) for long term maintenance.

I hope this is of some help.