https://community.qlik.com/t5/Talend-Studio/Components-to-clean-data/m-p/2250295#M34586 Hello.<BR />I am experiencing some difficulties cleaning my data. As of right now, I have partially cleaned the data. My data consist of delimiters&nbsp;such as space, comma. But after using a component, I&nbsp;realized that some data is lost due to "\n". Any idea how to clean data without losing any rows?&nbsp; Sat, 16 Nov 2024 10:12:13 GMT Anonymous 2024-11-16T10:12:13Z https://community.qlik.com/t5/Talend-Studio/Components-to-clean-data/m-p/2250295#M34586 Hello.<BR />I am experiencing some difficulties cleaning my data. As of right now, I have partially cleaned the data. My data consist of delimiters&nbsp;such as space, comma. But after using a component, I&nbsp;realized that some data is lost due to "\n". Any idea how to clean data without losing any rows?&nbsp; Sat, 16 Nov 2024 10:12:13 GMT https://community.qlik.com/t5/Talend-Studio/Components-to-clean-data/m-p/2250295#M34586 Anonymous 2024-11-16T10:12:13Z https://community.qlik.com/t5/Talend-Studio/Components-to-clean-data/m-p/2250296#M34587 Hi, <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">You can clean up using the tMap component to remove your data.&nbsp;</FONT></FONT> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">Try to use method substring(int beginIndex, int endIndex) in tMap expression.</FONT></FONT> <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">Best regards</FONT></FONT> <BR /> <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">Sabrina</FONT></FONT> Thu, 15 Dec 2016 10:03:05 GMT https://community.qlik.com/t5/Talend-Studio/Components-to-clean-data/m-p/2250296#M34587 Anonymous 2016-12-15T10:03:05Z