topic Re: replacing blanks with any values in a csv sheet in Talend Studio https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348012#M115195 <P>You don't tell us what you try to do...</P><P>Based on you case title, if you try to manipulate strings, ensure they are not null:</P><PRE>row1.myString != null ? row1.myString.replaceAll(" ", "") : null</PRE><P><SPAN>But I'm not a diviner...</SPAN></P> Sat, 26 May 2018 10:39:26 GMT TRF 2018-05-26T10:39:26Z replacing blanks with any values in a csv sheet https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348011#M115194 <P>am trying to load data from a csv file having 4 different sheets to 4 different filedelimited using tmap.. but its throwing null pointer exception..</P><P>&nbsp;</P> Sat, 26 May 2018 10:17:22 GMT https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348011#M115194 Anonymous 2018-05-26T10:17:22Z Re: replacing blanks with any values in a csv sheet https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348012#M115195 <P>You don't tell us what you try to do...</P><P>Based on you case title, if you try to manipulate strings, ensure they are not null:</P><PRE>row1.myString != null ? row1.myString.replaceAll(" ", "") : null</PRE><P><SPAN>But I'm not a diviner...</SPAN></P> Sat, 26 May 2018 10:39:26 GMT https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348012#M115195 TRF 2018-05-26T10:39:26Z Re: replacing blanks with any values in a csv sheet https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348013#M115196 <P>have attached my job... kindly check</P><BR /><A href="https://community.qlik.com/legacyfs/online/tlnd_dw_files/0683p000009LsuK">Exception in component tMap.docx</A> Sat, 26 May 2018 10:48:49 GMT https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348013#M115196 Anonymous 2018-05-26T10:48:49Z Re: replacing blanks with any values in a csv sheet https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348014#M115197 Share your tMap Sat, 26 May 2018 11:48:23 GMT https://community.qlik.com/t5/Talend-Studio/replacing-blanks-with-any-values-in-a-csv-sheet/m-p/2348014#M115197 TRF 2018-05-26T11:48:23Z