Hi Arun,arun@sinmax wrote: I need to check the presence of required fields and format of fields.
I tried by len(record) = length of record given in the metadata, but it doesn't work, also i tried using DCOUNT(record,'000'),it works for 05 Records but not for 10 and 15 type.
Can you provide more details about the file format -
Any delimiters
How many fields are there and
what format are you validating?
What is the purpose of DCOUNT here ?