Flat File Schema Validation - Delimited flat file

, ,
1

Dear All,

I have created a flat file schema for a Tab delimited flat file with 5 fields.
Delimiter - Tab
Record identifier - CRLF / New line

When i used convertTovalue with a file which has 6 fields in one of the record, i was expecting a ‘false’, but the result for validate is ‘true’

My intention is, if there is a mismatch in the fields numbers, than defined, i need to get validation error. Can anyone suggest how to accomplish it.

Thanks
Anish

2

Hi Anish,

can you check the resulting document after convert to value, if there is something like a *body content?

What is your IS version?
Fixes for IS and/or FlatFile?

Did you have a look at the FlatFile-Developers-Guide?

Regards,
Holger

3

Hi, Anish. Please check your record definition (Flat File Structure) tab and confirm that the value for the ‘Check Fields’ property is ‘True’. You may also wish to set the ‘Allow Undef Data’ property to ‘False’.

More details can be found in the Flat File Schema Developer’s Guide.
Thanks,
Mary

2 Likes
4

Hi,

thanks to Mary for enhancing the answer with more details.

Regards,
Holger

5

Thanks Mary,
It worked. Since I was using the ‘default record’ option, I couldn’t notice it in FF schema. For my case, I had to set it at the record level in FF dictionary.