LOAD DATA INFILE '/home/myusername/mysql/DRAWINGS.csv' INTO TABLE DwgsTbl
        FIELDS TERMINATED BY '|'
        ENCLOSED BY '"'
        LINES TERMINATED BY '\n'
        (QuoteNo, Updated, Keyword1, Keyword2, Material, fSize, DWGNo, Description, @var1, NTS, DOT, Customer, ProjectSpec, DwgSize, Detail, GD, DrawnBy, RecNo, Notes, @var2)
        SET createdDate = STR_TO_DATE(@var1, '%c/%e/%Y %H:%i:%s')
        /* SET Revision = IF(LENGTH(@var2) > 0, @var2, 0); */
        SET Revision = IF(@var2 RLIKE '^[0-9]+$', @var2,0);