reading a file

[greedyisg00d]

I have a table Company and all its data is tabulated in ms excel and then converted into notepad or text format. What I want is to read and echo the values of a specific column for example

Company Name | Address | Contacts No.

Thus I only want to echo all the data under the column Company Name. Also I want to insert the echoed data into the database

Any idea on how can this be done? Thanks

[dagon]

export it as csv then start with fgetcsv

[greedyisg00d]

Ok but how do I get and echo a specific column in a tab delimited text file just what I stated in my first posts. Thanks

[dagon]

did you bother to read the page? see the examples?

[greedyisg00d]

yes but still we are working on a tab delimited text file because the file came from excel and then exported as tab delimited text file not as CSV as you stated.

[dagon]

excel will save as csv

[greedyisg00d]

yes I know but exporting in "Text (Tab Delimited)" is one of the "requirements" in our project.

[johanafm]

fgetcsv is still valid. Once again, did you actually read the documentation?

PHP Documentation wrote:

delimiter

Set the field delimiter (one character only). Defaults as a comma.

How about changing the value of this paramter to something else, say a tab character?