https://communities.sas.com/t5/SAS-Programming/Extract-sentence-after-a-specific-word-in-a-string/m-p/861275#M340216 <P>Good Evening, I'm trying to extract the sentence from a specific text in a string. For example: the table below has the common word "Retail" and i would like to extract all the values from <EM><STRONG>Retail. Please assist. Thank you in advance.</STRONG></EM></P><P>&nbsp;</P><P>Input:</P><TABLE><TBODY><TR><TD>TEST DATA Retail-Drug name dosage and strength</TD></TR><TR><TD>HELLO DATA Retail Store closes at 8pm</TD></TR><TR><TD>WELCOME DATA Retail this is the data we needed</TD></TR><TR><TD>Good night DATA Retail Store opens at 9AM</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output:</P><TABLE><TBODY><TR><TD>Retail-Drug name dosage and strength</TD></TR><TR><TD>Retail Store closes at 8pm</TD></TR><TR><TD>Retail this is the data we needed</TD></TR><TR><TD>Retail Store opens at 9AM</TD></TR></TBODY></TABLE> Tue, 28 Feb 2023 04:01:42 GMT pappusrini 2023-02-28T04:01:42Z https://communities.sas.com/t5/SAS-Programming/Extract-sentence-after-a-specific-word-in-a-string/m-p/861275#M340216 <P>Good Evening, I'm trying to extract the sentence from a specific text in a string. For example: the table below has the common word "Retail" and i would like to extract all the values from <EM><STRONG>Retail. Please assist. Thank you in advance.</STRONG></EM></P><P>&nbsp;</P><P>Input:</P><TABLE><TBODY><TR><TD>TEST DATA Retail-Drug name dosage and strength</TD></TR><TR><TD>HELLO DATA Retail Store closes at 8pm</TD></TR><TR><TD>WELCOME DATA Retail this is the data we needed</TD></TR><TR><TD>Good night DATA Retail Store opens at 9AM</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected Output:</P><TABLE><TBODY><TR><TD>Retail-Drug name dosage and strength</TD></TR><TR><TD>Retail Store closes at 8pm</TD></TR><TR><TD>Retail this is the data we needed</TD></TR><TR><TD>Retail Store opens at 9AM</TD></TR></TBODY></TABLE> Tue, 28 Feb 2023 04:01:42 GMT https://communities.sas.com/t5/SAS-Programming/Extract-sentence-after-a-specific-word-in-a-string/m-p/861275#M340216 pappusrini 2023-02-28T04:01:42Z https://communities.sas.com/t5/SAS-Programming/Extract-sentence-after-a-specific-word-in-a-string/m-p/861283#M340222 <P>The FINDW function returns the position where a word is first found, which you can then use in SUBSTR.</P> Tue, 28 Feb 2023 06:10:02 GMT https://communities.sas.com/t5/SAS-Programming/Extract-sentence-after-a-specific-word-in-a-string/m-p/861283#M340222 Kurt_Bremser 2023-02-28T06:10:02Z