<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: write a routine to remove special characters in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292939#M65965</link>
    <description>&lt;P&gt;i want to create a routine to check whether this row has special characters and remove them .&lt;/P&gt;
&lt;P&gt;i know that i can do it by using:&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;ReplaceAll()&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;but want a routine to check for row whose type is string or integer.&lt;/P&gt;
&lt;P&gt;row1.data&lt;/P&gt;
&lt;P&gt;&lt;U&gt;nme(int)&lt;STRONG&gt;|&lt;/STRONG&gt; plc(str)&lt;/U&gt;&lt;/P&gt;
&lt;P&gt;1*2!@&lt;STRONG&gt;|&lt;/STRONG&gt;" fff#@&amp;nbsp; "&lt;/P&gt;
&lt;P&gt;want to remove all the special as well as spaces and empty string and append word&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 07 Aug 2018 07:01:10 GMT</pubDate>
    <dc:creator>sbxr</dc:creator>
    <dc:date>2018-08-07T07:01:10Z</dc:date>
    <item>
      <title>write a routine to remove special characters</title>
      <link>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292937#M65963</link>
      <description>&lt;P&gt;Hi Team,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have a row which contain data mix with some special characters.need a java code to filter them.&lt;/P&gt;
&lt;P&gt;please help me for both string and integer data types&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Mon, 06 Aug 2018 06:46:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292937#M65963</guid>
      <dc:creator>sbxr</dc:creator>
      <dc:date>2018-08-06T06:46:20Z</dc:date>
    </item>
    <item>
      <title>Re: write a routine to remove special characters</title>
      <link>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292938#M65964</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Could you please elaborate your case with an example with input and expected output values?&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Best regards&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;Sabrina&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN class="TextRun SCXP105466619" style="color: #000000; font-weight: normal; font-style: normal; text-decoration: none; font-size: 32px; font-family: Calibri, Calibri_MSFontService, sans-serif; font-variant: normal; letter-spacing: 0px; font-kerning: normal; line-height: 34.56px; vertical-align: -2.12551px; padding-top: 2.12551px;"&gt;&lt;SPAN class="NormalTextRun SCXP105466619" style="vertical-align: 2.12551px; line-height: 0px;"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 07 Aug 2018 03:30:16 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292938#M65964</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-08-07T03:30:16Z</dc:date>
    </item>
    <item>
      <title>Re: write a routine to remove special characters</title>
      <link>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292939#M65965</link>
      <description>&lt;P&gt;i want to create a routine to check whether this row has special characters and remove them .&lt;/P&gt;
&lt;P&gt;i know that i can do it by using:&lt;/P&gt;
&lt;P&gt;&lt;STRONG&gt;ReplaceAll()&amp;nbsp;&lt;/STRONG&gt;&lt;/P&gt;
&lt;P&gt;but want a routine to check for row whose type is string or integer.&lt;/P&gt;
&lt;P&gt;row1.data&lt;/P&gt;
&lt;P&gt;&lt;U&gt;nme(int)&lt;STRONG&gt;|&lt;/STRONG&gt; plc(str)&lt;/U&gt;&lt;/P&gt;
&lt;P&gt;1*2!@&lt;STRONG&gt;|&lt;/STRONG&gt;" fff#@&amp;nbsp; "&lt;/P&gt;
&lt;P&gt;want to remove all the special as well as spaces and empty string and append word&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 07 Aug 2018 07:01:10 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292939#M65965</guid>
      <dc:creator>sbxr</dc:creator>
      <dc:date>2018-08-07T07:01:10Z</dc:date>
    </item>
    <item>
      <title>Re: write a routine to remove special characters</title>
      <link>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292940#M65966</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt; 
&lt;P&gt;Could you please let us know if this topic:&lt;A title="https://community.talend.com/t5/Design-and-Development/Regex-Expression-in-tmap/m-p/39391" href="https://community.qlik.com/s/feed/0D53p00007vCprWCAS" target="_self"&gt;https://community.talend.com/t5/Design-and-Development/Regex-Expression-in-tmap/m-p/39391&lt;/A&gt; helps?&lt;/P&gt; 
&lt;P&gt;Best regards&lt;/P&gt; 
&lt;P&gt;Sabrina&lt;/P&gt;</description>
      <pubDate>Wed, 15 Aug 2018 04:25:15 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/write-a-routine-to-remove-special-characters/m-p/2292940#M65966</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-08-15T04:25:15Z</dc:date>
    </item>
  </channel>
</rss>

