topic Re: Formula to search for specific sign in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84872#M14232 <HTML><HEAD></HEAD><BODY><P>thanks it works</P></BODY></HTML> Mon, 26 Mar 2018 11:48:10 GMT markus_dreuw 2018-03-26T11:48:10Z Formula to search for specific sign https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84870#M14230 <HTML><HEAD></HEAD><BODY><P> <SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Good morning</SPAN></P><P style="margin-top: 2.0pt; margin-bottom: 2.0pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">I would like to evaluate a column by controlling if it contains an e-mail addresses respectively an “@”. Before and after the “@” different content can be given, numbers, letters etc. It just has to be controlled if there is an “@” in it.</SPAN></P><P style="margin-top: 2.0pt; margin-bottom: 2.0pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Is there any formula to do so? Maybe working with an if clause? </SPAN></P><P style="margin-top: 2.0pt; margin-bottom: 2.0pt;"><SPAN style="font-size: 12.0pt; font-family: 'Times New Roman',serif;">Thank you in advance</SPAN></P></BODY></HTML> Sat, 16 Nov 2024 08:30:17 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84870#M14230 markus_dreuw 2024-11-16T08:30:17Z Re: Formula to search for specific sign https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84871#M14231 <HTML><HEAD></HEAD><BODY><P>I'm not sure where/how you want to use this logic, but</P><P></P><P>Implicit:</P><P><SPAN style="font-size: 13.3333px;"><EM>(Index(MailAddress, '@') &gt; 0)</EM></SPAN></P><P></P><P>Explicit:</P><P><EM>If(Index(MailAddress, '@') &gt; 0, true(), false())</EM></P></BODY></HTML> Mon, 26 Mar 2018 08:29:13 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84871#M14231 jonathandienst 2018-03-26T08:29:13Z Re: Formula to search for specific sign https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84872#M14232 <HTML><HEAD></HEAD><BODY><P>thanks it works</P></BODY></HTML> Mon, 26 Mar 2018 11:48:10 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Formula-to-search-for-specific-sign/m-p/84872#M14232 markus_dreuw 2018-03-26T11:48:10Z