hi
I have to validate the data of a tab-delimited files. If all is well in the office database. What I have to do is
1 - Validate if the correct number of fields in each record
2 - Validate the length of the field
3 - Validate that if they meet a decimal formats.
4 - Validate that certain fields have values that are in database tables
5 - If no date fields have to satisfy a pattern
6 - Report of the errors of each record
I can not use tschemaconpliancecheck and delimited file option to verify the structure of each row against the schema
Assuming that the field delimiter is the tab end of the file I have a number of lines that are not fixed at the end as
-->-->-->-->-->
-> ->
->
->->->->->->
I can come sometimes 3 lines, other 4 and other n.
I also want to know how to load these files when satisfied that everything is correct
Regards,
Oscar Manso
