Hello all, I am writing to ask what is the best way to write the sql statement to upload a fixed width file?
like 0123456789Company name Boston MA02215-1234 first field starts on 0 and has 9 char next filed starts on 9 and has 22 char next field starts on 30 and has 10 char and etc etc the numbers that I am using may be wrong as I am just creating a example of the file which is much bigger START CODE LOAD DATA INFILE 'EO4.LST' INTO TABLE irs_eoml (@var1) SET EIN = substr( @var1 , 0, 9 ) , PNO = substr( @var1 , 9, 70 ) , ICN = substr( @var1 , 79, 35 ) , Street_Address = substr( @var1 , 114, 35 ) , City = substr( @var1 , 149, 22 ) , State = substr( @var1 , 171, 2 ) , Postal_Code = substr( @var1 , 173, 10 )"; END CODE Any help would be great, thanks ahead of time! Christopher
