https://community.qlik.com/t5/Talend-Studio/separator-check/m-p/2240139#M27723 <P>Hello,</P><P>I want to do a sperator check in an incoming CSV file, for example if I have a separator other than";" I reject the file, also for encoding "utf_8" and returns to the line '\n'&nbsp; , otherwise I continue my processing &nbsp;</P><P>big thanks</P><P>&nbsp;</P> Sat, 16 Nov 2024 07:19:08 GMT Anonymous 2024-11-16T07:19:08Z https://community.qlik.com/t5/Talend-Studio/separator-check/m-p/2240139#M27723 <P>Hello,</P><P>I want to do a sperator check in an incoming CSV file, for example if I have a separator other than";" I reject the file, also for encoding "utf_8" and returns to the line '\n'&nbsp; , otherwise I continue my processing &nbsp;</P><P>big thanks</P><P>&nbsp;</P> Sat, 16 Nov 2024 07:19:08 GMT https://community.qlik.com/t5/Talend-Studio/separator-check/m-p/2240139#M27723 Anonymous 2024-11-16T07:19:08Z https://community.qlik.com/t5/Talend-Studio/separator-check/m-p/2240140#M27724 <P>Logically there is no need to do this.</P> <P>&nbsp;</P> <P>If you use your tFileInputDelimited component and configure it to use a ";" as the separator, you can throw the file away (or reject it) if your columns are missing data. If you have 5 columns of data and there are no ";" in there, it will mean that only your first column will have data. Columns 2, 3,4 and 5 will not be consistently populated.&nbsp;</P> <P>&nbsp;</P> <P>Adding a checking stage before attempting to process it will probably be less efficient than checking it while you consume it.&nbsp;</P> Tue, 13 Nov 2018 16:06:35 GMT https://community.qlik.com/t5/Talend-Studio/separator-check/m-p/2240140#M27724 Anonymous 2018-11-13T16:06:35Z