|
Hello,
Thanks for the great parser and for keeping it up-to-date!
I have a small 80GB file the I'm working on but the header record is wrapped in quotes which generates an error. Here is the header record and first record:
"Household_Member1","Address","City_State_Zip","Area_Code_and_Phone","Phone_Area_Code","Phone_Number_without_Area_Code","City","State","ZIP","ZIP_+_4","ZIP_+_4_+_DPBC","Delivery_Point_Bar_Code","Carrier_Route","County","MSA","Household_Member_First1","Household_Member_Last1","Household_Member_Gender1","Household_Member_Age1","Household_Member2","Household_Member_First2","Household_Member_Last2","Household_Member_Gender2","Household_Member_Age2","Household_Member3","Household_Member_First3","Household_Member_Last3","Household_Member_Gender3","Household_Member_Age3","Household_Member4","Household_Member_First4","Household_Member_Last4","Household_Member_Gender4","Household_Member_Age4","Household_Member5","Household_Member_First5","Household_Member_Last5","Household_Member_Gender5","Household_Member_Age5","Household_Member6","Household_Member_First6","Household_Member_Last6","Household_Member_Gender6","Household_Member_Age6","Household_Member7","Household_Member_First7","Household_Member_Last7","Household_Member_Gender7","Household_Member_Age7","Household_Member8","Household_Member_First8","Household_Member_Last8","Household_Member_Gender8","Household_Member_Age8","Household_Member9","Household_Member_First9","Household_Member_Last9","Household_Member_Gender9","Household_Member_Age9","Household_Member10","Household_Member_First10","Household_Member_Last10","Household_Member_Gender10","Household_Member_Age10","Residence_Type","Home_Age","Est_Home_Value","Est_Income","Own/Rent","Length_of_Residence","Mortgage_Age","Mortgage_Count","Mortgage_Finance_Type","Mortgage_Loan_to_Value_Ratio","Mortgage_Loan_Type","Personal_Details1","Personal_Details2","Personal_Details3","Personal_Details4","Personal_Details5","Mail_Order_Buyer1","Mail_Order_Buyer2","Mail_Order_Buyer3","Mail_Order_Buyer4","Mail_Order_Buyer5","Mail_Order_Buyer6","Mail_Order_Buyer7","Mail_Order_Buyer8","Mail_Order_Buyer9","Mail_Order_Buyer10","Mail_Order_Buyer11","Mail_Order_Buyer12","Mail_Order_Buyer13","Mail_Order_Buyer14","Mail_Order_Buyer15","Mail_Order_Buyer16","Mail_Order_Buyer17","Mail_Order_Buyer18","Mail_Order_Buyer19","Mail_Order_Buyer20","Mail_Order_Buyer21","Mail_Order_Buyer22","Mail_Order_Buyer23","Mail_Order_Buyer24","Donor_Type1","Donor_Type2","Donor_Type3","Donor_Type4","Donor_Type5","timezone","latitude","longitude"
"Rose M Modarelli",""2822 Bears Den CT","Youngstown, OH 44511-1214","","","","Youngstown","OH","44511","44511-1214","44511-1214-223","223","C090","Mahoning","Youngstown-Warren, OH","Rose","Modarelli","F","65 and older","Dina M Modarelli","Dina","Modarelli","F","25 to 34","Dominic G Modarelli","Dominic","Modarelli","M","25 to 34","Frank J Modarelli","Frank","Modarelli","M","45 to 54","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","Single family dwelling","","","","Home Owner","26 to 30 years","26 to 30 years","Unknown","Unknown","0.01 to 0.09","Unknown","Pool","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","EST",80.696899999999999,41.069099999999999
Works fine if I take the quotes off the header record. I get a lot of these files in so if I can make the parser handle it that would be better than appending a new header to these file since they are so large.
I know you are a busy guy so if you can point me in the general direction I'll try to make the change myself. Thanks again for your time.
Chad
|
|
|
|