Hi All,
I would like to ask your help for the following question:
I have some huge CSV/TXT files (over 1.5GB of size each), and I would like to load just a few lines of such files. The reason is because I need to link the field name of the file to my principal database field name. So I don't really need to load the entire file (which can take a while) in the memory. Only a few lines would be enough. Some thing like that
ID;NAME;ADDRESS;CITY
1;JOSH;1 MAIN STREET;BOSTON
2;EMILY;1 MAIN STREET;BOSTON
3;BILL;1 MAIN STREET;BOSTON
The above option will give me exactly what I need to know, which is load the field name(ID,NAME,ADDRESS, CITY) and just a few records for reference. Not the entire (1.5GB) file.
So how could I accomplish such thing?
thanks in advance.
J