https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275386#M51780 <P>I have a column of data from IBM BigFix that lists all software on a pc, but the cell contains "software | version" on separate lines within the cell for each software installed. I'm trying to use tNormalize, but how do I specify carriage return as the delimiter?</P> Tue, 01 Oct 2019 17:08:15 GMT Phil3 2019-10-01T17:08:15Z https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275386#M51780 <P>I have a column of data from IBM BigFix that lists all software on a pc, but the cell contains "software | version" on separate lines within the cell for each software installed. I'm trying to use tNormalize, but how do I specify carriage return as the delimiter?</P> Tue, 01 Oct 2019 17:08:15 GMT https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275386#M51780 Phil3 2019-10-01T17:08:15Z https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275387#M51781 I've tried "\r\n" but that doesn't seem to work. Any ideas? Tue, 01 Oct 2019 19:15:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275387#M51781 Phil3 2019-10-01T19:15:10Z https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275388#M51782 "\n" works. FYI. Wed, 02 Oct 2019 12:03:59 GMT https://community.qlik.com/t5/Talend-Studio/How-to-specify-carriage-return-as-delimiter-in-tNormalize/m-p/2275388#M51782 Phil3 2019-10-02T12:03:59Z