Manipulate form text data copied from excel to be placed into an array

[dammyg]

Hi, first time posting here, I don't know much about php but know some basics, I am trying to get data copied from excel to be split up into an array, If i copy data from excel each column is seperated by tabs and each row is seperated by being placed on a new row, if i enter this into a textarea box in a form i wish for each row to be recorded as a seperate person and each column as a different value for that person.

 

example:

 

customer1  5  1st

customer2  7  2nd

customer3  3  1st

 

Any help will be much appreciated.

Thank You

[chronister]

Check out this post I made a while back. It contains 2 "pages" of code to take a csv file and flip it around to create an associative array that you can do with what you will. I use it to upload a csv file, extract the data and then insert into the db.

 

http://www.phpfreaks.com/forums/index.php/topic,156812.0.html

 

Any questions with it, lemme know.

 

Nate

[dammyg]

Hi, I'll have a look at it and see what I can do and give some feedback later.

 

Thank you very much

[dammyg]

worked great, thanks.

Just having a few problems with something else that i wanted to use at the same time:(