https://community.qlik.com/t5/Data-Quality/Handling-Quotes-and-Null-values-in-a-column/m-p/2464942#M4052 <P>I am new to Talend so requiring help during development. I have quotes in some rows of the table but not others (having null values). I had to remove the quotes from the rows and also handle nulls for others rows. I used replace function for remove quotes but it is throwing null exception. Require help here for resolving this issue. Example is as below</P> <P><STRONG>Input:</STRONG></P> <TABLE width="109"> <TBODY> <TR> <TD width="109">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> </TR> <TR> <TD>"211"</TD> </TR> <TR> <TD>"211"</TD> </TR> <TR> <TD>"123,999"</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P><STRONG>Required Output:</STRONG></P> <TABLE width="109"> <TBODY> <TR> <TD width="109">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> </TR> <TR> <TD>211</TD> </TR> <TR> <TD>211</TD> </TR> <TR> <TD>123,999</TD> </TR> </TBODY> </TABLE> Mon, 24 Jun 2024 12:15:51 GMT dhnaz_yus07 2024-06-24T12:15:51Z https://community.qlik.com/t5/Data-Quality/Handling-Quotes-and-Null-values-in-a-column/m-p/2464942#M4052 <P>I am new to Talend so requiring help during development. I have quotes in some rows of the table but not others (having null values). I had to remove the quotes from the rows and also handle nulls for others rows. I used replace function for remove quotes but it is throwing null exception. Require help here for resolving this issue. Example is as below</P> <P><STRONG>Input:</STRONG></P> <TABLE width="109"> <TBODY> <TR> <TD width="109">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> </TR> <TR> <TD>"211"</TD> </TR> <TR> <TD>"211"</TD> </TR> <TR> <TD>"123,999"</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P><STRONG>Required Output:</STRONG></P> <TABLE width="109"> <TBODY> <TR> <TD width="109">&nbsp;</TD> </TR> <TR> <TD>&nbsp;</TD> </TR> <TR> <TD>211</TD> </TR> <TR> <TD>211</TD> </TR> <TR> <TD>123,999</TD> </TR> </TBODY> </TABLE> Mon, 24 Jun 2024 12:15:51 GMT https://community.qlik.com/t5/Data-Quality/Handling-Quotes-and-Null-values-in-a-column/m-p/2464942#M4052 dhnaz_yus07 2024-06-24T12:15:51Z https://community.qlik.com/t5/Data-Quality/Handling-Quotes-and-Null-values-in-a-column/m-p/2465011#M4053 <PRE><STRONG>Replace(Value,Chr(34),'')<BR /><BR /><EM>*</EM>Value <EM>will be your field name</EM></STRONG></PRE> Mon, 24 Jun 2024 14:24:17 GMT https://community.qlik.com/t5/Data-Quality/Handling-Quotes-and-Null-values-in-a-column/m-p/2465011#M4053 HirisH_V7 2024-06-24T14:24:17Z