topic Data cleaning before loading in Talend Studio https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229202#M20219 <P>Hello!</P> <P>I have an issue in data. From one of the application I am loading project related information in DIM_PROJECT. But few columns has following format:</P> <TABLE> <TBODY> <TR> <TD>PROJECTNUMBER</TD> <TD>BUILDING</TD> </TR> <TR> <TD>10001</TD> <TD>["New","Rehab","Annex"]</TD> </TR> <TR> <TD>10002</TD> <TD>["New"]</TD> </TR> <TR> <TD>10003</TD> <TD>["New","Rehab"]</TD> </TR> <TR> <TD>10004</TD> <TD>["New"]</TD> </TR> <TR> <TD>10005</TD> <TD>["Rehab","Vehicles"]</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to remove this -- [""] from the values.&nbsp;</P> <TABLE> <TBODY> <TR> <TD>PROJECTNUMBER</TD> <TD>BUILDING</TD> </TR> <TR> <TD>10001</TD> <TD>New,Rehab,Annex</TD> </TR> <TR> <TD>10002</TD> <TD>New</TD> </TR> <TR> <TD>10003</TD> <TD>New,Rehab</TD> </TR> <TR> <TD>10004</TD> <TD>New</TD> </TR> <TR> <TD>10005</TD> <TD>Rehab,Vehicles</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How can I achieve this?</P> <P>&nbsp;</P> <P>Regards</P> <P>Priya</P> Sat, 16 Nov 2024 05:17:06 GMT Anonymous 2024-11-16T05:17:06Z Data cleaning before loading https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229202#M20219 <P>Hello!</P> <P>I have an issue in data. From one of the application I am loading project related information in DIM_PROJECT. But few columns has following format:</P> <TABLE> <TBODY> <TR> <TD>PROJECTNUMBER</TD> <TD>BUILDING</TD> </TR> <TR> <TD>10001</TD> <TD>["New","Rehab","Annex"]</TD> </TR> <TR> <TD>10002</TD> <TD>["New"]</TD> </TR> <TR> <TD>10003</TD> <TD>["New","Rehab"]</TD> </TR> <TR> <TD>10004</TD> <TD>["New"]</TD> </TR> <TR> <TD>10005</TD> <TD>["Rehab","Vehicles"]</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want to remove this -- [""] from the values.&nbsp;</P> <TABLE> <TBODY> <TR> <TD>PROJECTNUMBER</TD> <TD>BUILDING</TD> </TR> <TR> <TD>10001</TD> <TD>New,Rehab,Annex</TD> </TR> <TR> <TD>10002</TD> <TD>New</TD> </TR> <TR> <TD>10003</TD> <TD>New,Rehab</TD> </TR> <TR> <TD>10004</TD> <TD>New</TD> </TR> <TR> <TD>10005</TD> <TD>Rehab,Vehicles</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How can I achieve this?</P> <P>&nbsp;</P> <P>Regards</P> <P>Priya</P> Sat, 16 Nov 2024 05:17:06 GMT https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229202#M20219 Anonymous 2024-11-16T05:17:06Z Re: Data cleaning before loading https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229203#M20220 <P>This bit of code should work for you. It is using a standard piece of Java String manipulation. If your data is in a column called "data" from a row called "row1", your code would look like this...</P> <P>&nbsp;</P> <PRE>row1.data.replaceAll("[\\[\\]\\\"]", "")</PRE> Mon, 15 Jul 2019 08:56:16 GMT https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229203#M20220 Anonymous 2019-07-15T08:56:16Z Re: Data cleaning before loading https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229204#M20221 <P><A href="https://community.qlik.com/s/profile/005390000069RuGAAU">@rhall</A>&nbsp;Thanks! That worked! <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span></P> Mon, 15 Jul 2019 09:31:21 GMT https://community.qlik.com/t5/Talend-Studio/Data-cleaning-before-loading/m-p/2229204#M20221 Anonymous 2019-07-15T09:31:21Z