I'm writing a module that validates a csv file against a simple schema, here is an example on how it should work:
Simple schema(might be given in a file or as argument): int, char, char, date,bool Here is a sample of valid data: 123, hello, all, 12/12/06, 0 in my program I only need dates with the (MM/DD/YY) format and 0/1 booleans. but extending that won't be a tough problem. I also think that auto sql generation will be usefull. On 1/4/07, Jad madi <[EMAIL PROTECTED]> wrote:
I second Ammai, there is and there should be a universal validator, it depends on your data 7aj On 1/3/07, Ammar Ibrahim <[EMAIL PROTECTED]> wrote: > It would be easy to write a validator yourself to check on the number of > column, but as for the types of data, this is more of a business logic in > your application, and I doubt you'd find anything like that. Best thing to > do is to write one yourself. > > > - Ammar > > On 1/3/07, etoom etoom <[EMAIL PROTECTED]> wrote: > > > > yes of course, the number of columns, the type of data each column is > > supposed to have (numbers, dates,..). that's it. > > > > On 1/3/07, Ammar Ibrahim <[EMAIL PROTECTED] > wrote: > > > What would make a CSV file valid or invalid? e.g. every record to have > the > > > same number of column? etc > > > > > > - Ammar > > > > > > > > > > > > On 1/3/07, etoom etoom < [EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Salam all, > > > > I'm trying to read a csv (comma separated values) file and store the > > > > values in a database using perl, every thing is going great except I > > > > can't find any module that validates csv file against a schema of some > > > > form like we have in xml. Is their any? > > > > > > > > Yazan > > > > > > > > > > > > > > > > > > > > > > > > > > >
--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Jolug" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups-beta.google.com/group/Jolug?hl=en-GB -~----------~----~----~----~------~----~------~--~---

