Checking number of delimiters

Hello

I have scenario where my flat file contains 13 fields.
My import has to fail if my flat file comes with != 13 fields in the file.

Please help me.
Thanks,
Jean

Say for example your delimiter is comma.
So every line in the source file must have 12 commas.
Use Keep characters to delete all characters except commas,
Measure length of resulting string.
If it is not 12 abort processing.

Thank you for detailed explanation.
I have never thought about fake delimiter

I am loading data into Oracle and I do not want to load any data from the files with problems.
If file is very big and the error is towards the end of the file I do not want to load data before the line with the problem :whistle:

Just put sorter object in the middle.
Than in case of validation error no data will be passed to the writer