Attached is a sample fixed width file of a flie I've downloaded from the FDA site. (I deleted most of the lines because it's huge.) This file, along with others, can be used to create a database of all the OTC & Rx drugs & the companies who registered them.
I haven't imported from a fixed width file before & I'm having problems.
Here is the structure for this file:
ListingSeqNum Not Null Num(7) Col: 1-7 Primary Key
LblCode Not Null Char(6) Col: 9-14
ProdCode Not Null Char(4) Col: 16-19
Strength Null Char(10) Col: 21-30
Unit Null Char(10) Col: 32-41
Rx-OTC Not Null Char(1) Col: 43
Tradename Not Null Char(100) Col: 45-144
Here are my questions:
1. In the text file, there is a single space after every entry. Should I treat that space as a seperate column or as a field terminator?
2. When you look at a fixed width file, is there a way to determine what the field & row terminators are? LISTINGS-X.TXT