Configuration of tFileInputDelimited

[idembel2]

Hello All,

I have another chalenge, so may somebody help me please.

I have a csv file which look like that

ID	Name	Comment	Poste
1	toto	tre;gtt	director
2	titi	dftgrtg	ceo
3	tata	dfgtg	technician
4	tutut	ytr;nhhc	ttt
5	lolo	dcvdrf	ttt
6	lala	dfdf	ttt

I configure tFileInputDelimited component like in attached file. 

My problem is that in comment field, sometime user can put symbol ; in there comment and this impact my output.

So i think the option "Dynamic setting" of this component can help me to solve it, but i don't know how to do it.

Or if somebody can advice me other solution.

Thanks,

[idembel2]

Hello TRF,

Thank you very much for your suggestion, it works

And i am sorry for this long time to give you feedback.

[Anonymous]

Hi Team,

I need to process tab delimited file. For input - I am using tfileinputexcel  (file extension - .xls)

Getting below error -

[statistics] connecting to socket on port 3796
[statistics] connected
Exception in component tFileInputExcel_1 (cd_extract_job_xls)
org.apache.poi.openxml4j.exceptions.NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file
at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.getNextEntry(ZipArchiveThresholdInputStream.java:144)
at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:49)
at org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:214)
at org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:198)
at org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:172)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:153)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:123)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:233)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:166)
at org.apache.poi.ooxml.POIXMLDocument.openPackage(POIXMLDocument.java:89)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:336)
at team_ja_central_demand.cd_extract_job_xls_0_1.cd_extract_job_xls.tFileInputExcel_1Process(cd_extract_job_xls.java:10358)
at team_ja_central_demand.cd_extract_job_xls_0_1.cd_extract_job_xls.runJobInTOS(cd_extract_job_xls.java:53163)
at team_ja_central_demand.cd_extract_job_xls_0_1.cd_extract_job_xls.main(cd_extract_job_xls.java:53013)
Caused by: java.util.zip.ZipException: Unexpected record signature: 0X6E656449
at org.apache.commons.compress.archivers.zip.ZipArchiveInputStream.getNextZipEntry(ZipArchiveInputStream.java:260)
at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.getNextEntry(ZipArchiveThresholdInputStream.java:140)
... 13 more
[statistics] disconnected

Could you please help me with this why I am getting this error