topic Extracting Titles and footnotes from RTF table mock shells in SAS Programming

Extracting Titles and footnotes from RTF table mock shells

SASuserlot — Fri, 13 Nov 2020 20:26:03 GMT

We have the RTF file which contains hundreds of table mock shells. I want to extract all the titles and footnotes from rtf file and create a Excel file /SAS dataset where I can use them in the macro. I gone through the lot of papers, I am not sure the entire process is depends on SAS programming itself. I will be very thankful for your suggestions and inputs. I am attaching a sample RTF file.

Thanks

Re: Extracting Titles and footnotes from RTF table mock shells

ballardw — Fri, 13 Nov 2020 20:51:47 GMT

I don't open DOCX or similar files due to security issues.

Basically there really isn't any "nice" or easy way to extract anything from Word, RTF or other word processing format file.

Basic procedure is going to be to copy the text from the document and place into an appropriate statement in SAS program code.

Re: Extracting Titles and footnotes from RTF table mock shells

SASuserlot — Fri, 13 Nov 2020 21:11:01 GMT

thanks for you suggestions, however its little time taking when we have the thousands of tables. by the way sas websites scan for viruses when they upload any document . they will reject if they feel its not secure. Any way its individuals choice to open the uploaded document or not. thanks again.

Re: Extracting Titles and footnotes from RTF table mock shells

Ksharp — Sat, 14 Nov 2020 11:48:26 GMT

It is not a rtf file ,it is a word file.
rtf is more like text file, open it via NotePad++ and searching title in it by writing some code.