https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346088#M113532 <P>I have a CSV File in which last Row is violated, ScreenShot is being Attached Below.&nbsp;</P> <P>How can i remove 3 semicolons using StringHandling.ERREPLACE() i.e.</P> <P>which syntax will be use to remove 3 semicolons ";;;" using&nbsp;<SPAN>String</SPAN>Handling.ERREPLACE<SPAN>().</SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Total_Calls row is Violated by three semicolons" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxG9.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144170iA1B51C586D8A8F55/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxG9.png" alt="0683p000009LxG9.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Total_Calls row is Violated by three semicolons</SPAN></SPAN></SPAN></P> Sat, 16 Nov 2024 08:13:03 GMT Anonymous 2024-11-16T08:13:03Z https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346088#M113532 <P>I have a CSV File in which last Row is violated, ScreenShot is being Attached Below.&nbsp;</P> <P>How can i remove 3 semicolons using StringHandling.ERREPLACE() i.e.</P> <P>which syntax will be use to remove 3 semicolons ";;;" using&nbsp;<SPAN>String</SPAN>Handling.ERREPLACE<SPAN>().</SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Total_Calls row is Violated by three semicolons" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxG9.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144170iA1B51C586D8A8F55/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxG9.png" alt="0683p000009LxG9.png" /></span><SPAN class="lia-inline-image-caption" onclick="event.preventDefault();">Total_Calls row is Violated by three semicolons</SPAN></SPAN></SPAN></P> Sat, 16 Nov 2024 08:13:03 GMT https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346088#M113532 Anonymous 2024-11-16T08:13:03Z https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346089#M113533 <P><A href="https://community.qlik.com/s/profile/0053p000007LOQUAA4">@meetmahajan</A>,can you use below funtion in tMap.</P> <P>&nbsp;</P> <P>row1.total.replace(";","")</P> <P><SPAN>row1.total.replaceAll(";","")</SPAN></P> Fri, 25 May 2018 07:21:28 GMT https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346089#M113533 manodwhb 2018-05-25T07:21:28Z https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346090#M113534 Try StringHandling.ERREPLACE(yourString, ";;;$", "") or StringHandling.ERREPLACE(yourString, "\;\;\;$", "") Fri, 25 May 2018 07:22:22 GMT https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346090#M113534 TRF 2018-05-25T07:22:22Z https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346091#M113535 <P><A href="https://community.qlik.com/s/profile/0053p000007LKmJAAW">@manodwhb</A>&nbsp;<A href="https://community.qlik.com/s/profile/0053p000007LKj7AAG">@TRF</A></P> <P>Thank you so much&nbsp;</P> <P>Both Method Works very Well <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot (38).png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LxM6.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151113iDB2ACC187BF0A6F8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LxM6.png" alt="0683p000009LxM6.png" /></span></SPAN>&nbsp;</P> Fri, 25 May 2018 07:25:23 GMT https://community.qlik.com/t5/Talend-Studio/Issue-Regarding-Violated-Column-in-Excel/m-p/2346091#M113535 Anonymous 2018-05-25T07:25:23Z