https://community.cloudera.com/t5/Support-Questions/Find-a-word-or-a-group-of-words-from-a-column-in-Hortonworks/m-p/214980#M176892 <P>Hi, <A rel="user" href="https://community.cloudera.com/users/79158/vmurakami.html" nodeid="79158">@Vinicius Higa Murakami</A></P><P>Thank you for taking out your time to help me. The regexp_extract didnt work correctly but I got the idea and modified the code to get the desired results.</P><P>Here is what I did:</P><P><EM><STRONG>trim(concat_ws(' ', case when instr( lower(col4) , 'abcd' ) &gt;0 then 'abcd' else '' end, </STRONG></EM></P><P><EM><STRONG>case when instr( lower(col4) , 'pqrs' ) &gt;0 then 'pqrs' else '' end))</STRONG></EM></P><P><EM><STRONG><BR /></STRONG></EM></P><P>This worked perfectly. Thank you so much</P><P><STRONG><BR /></STRONG></P><P>Regards</P><P>Souveek</P> Thu, 07 Jun 2018 14:48:50 GMT souveekray 2018-06-07T14:48:50Z