[antlr-interest] Generate Grammar out of Table Definition

René Schrader-Bölsche rsb at villa-cossio.com
Sun Nov 1 01:24:08 PDT 2009


Hi,

for a big BI-Project I have to import big CSV-Files. But,  
unfortunately, sometimes the mandatory values are missing. Now I am  
looking for a "script" which generates a grammar directly from the  
"Table Definition" stored inside Oracle.

Here is an example:

Imagine I do have such a "create table" statement (pseudo SQL :-)

create table myANTLR (
field1 integer mantatory,
field2 string mandatory,
field3 string optional
)

I get such CSV files, which I want to parse.

1,Hello, You
2,No,
3,Mike, Judy

I want to find errors like this one (second entry is missing):
4,,Bob

Do you have any ideas???

Best wishes and (un)happy Halloween
Rene

Rene Schrader-Boelsche      rene<at>villa-cossio.com
Am Ringofen	 25                www.villa-cossio.com
D-50321 Bruehl                    +49 (0)171 5482906





More information about the antlr-interest mailing list