Question: I have txt file where the first row contains the column names. But some rows have no title, I would like to know if there is any solution to remove those rows without column names into my txt file?

To access to my txt file:

```
$handleFile= fopen("/opt/lampp/htdocs/ngs/tmp/testfile.txt","r");
$dataTestFile=fgetcsv($handleFile,0,"\t");

```

Here's an example:

```
Data1;Data2;;Input;;
aaaaa;ferfs;;alpha;dfdfd;

```

**Desired output:**

```
Data1;Data2;Input;
aaaaa;ferfs;alpha;

```

First row is column names, and some of them haven't any names, I need to remove all columns which have no names.

Thanks.

Answer: 
> 
> Is it not allowed to pass null value to SQL?
> 
> 
> 

It is, but it can't be done by stating a space. You must write Null:

```
VALUES (61,66,134,1,1,'STRUCTURAL DESIGN',Null,'AWARDED','Test LPO',#2/11/2016#,Null,Null,Null,Null,'Dnata 4 storey warehouse Alquoz',Null)

```

and quotes and date delimiters are missing.
You wrote this:

```
theSQL = "INSERT INTO tbl_PROJECTS (co_id, contact_id, prop_id, worktype_id, incharge_id, project_name, project_ref," _
    & "project_status, project_awardref, project_awarddate, project_startdate, project_targetdate," _
    & "project_completedate, project_finalreportdate, project_location, project_notes)"

theSQL = theSQL & " VALUES (" & theCoID & "," & theContactID & "," & thePropID & "," & theWorkTypeID & "," & theInCharge & "," _
      & "'" & theProjectName & "'" & "," & theProjectRef & "," & theProjectStatus & "," & theAwardRef _
      & theAwardDate & "," & theStartDate & "," & theTargetDate & "," & theCompleteDate & "," & theFinalReportDate & "," _
      & theLocation & "," & theNotes & ")"

```

In the second line in the second block, there's no ending quotes.