Click to See Complete Forum and Search --> : Transfer data from Email to Excel file


abhi
05-02-2006, 12:50 PM
I'm trying to transfer text data from my email to an excel file, but the problem is I don't know how to cordinate each category in separate cells.

Example(This is what I get in my email)
FirstName : John
LastName : Smith

With this info I want to put "John" under First Name column and "Smith" under LastName column in the excel file on my computer. How would go about doing this??

Thank you for your help

russell
05-02-2006, 01:00 PM
You are going to need to do some programming. What language(s) are you familiar with?

abhi
05-02-2006, 01:35 PM
I know HTML, JavaScript, and very little php

russell
05-02-2006, 02:58 PM
well, you're going to need a way to save the email, or the contents of the email as a file, then write a php script to parse it. the split() (http://www.php.net/manual/en/function.split.php) function will be helpful.

abhi
05-02-2006, 04:38 PM
Are there any examples which uses split() in a similar manner OR examples or Tutorials that explain parsing data??

Thank you very much

russell
05-02-2006, 05:11 PM
http://www.php.net/manual/en/function.split.php

also, try posting in php section for saving off as a file and parsing.

php.net (along with this forum of course) should be your favorite web site if you are learning php