Email as text file into csv format

Page 1 of 1

4 Replies - 836 Views - Last Post: 27 February 2011 - 02:38 AM

#1 Drachsi   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 27-February 11

Email as text file into csv format

Posted 27 February 2011 - 12:30 AM

Sorry everybody I am here to ask how to do something I have no idea about.I have about 1000 html emails which I have been asked to convert into text format. I need to convert the information into .csv automaticaly. Is this possible, and how?

A typical format is like the following.

Date: 24-Feb-2011
Name: P Somebody
Email: [email protected]
Email Confirmed: [email protected]
Alternative email: [email protected]
Confirm alternative: [email protected]
Address 1: Wil Street
Address 2: Well Road
City or Town: Nottshill
Post Code: Nk19 8ER
Country: United Kingdom
Vat: Yes
Newsletter: yes
Lathe Owner: Yes
Model: SL7
Serial number: yt548723
Special: Hobbyist
Website: No website
Product Changes: yes
New Products: yes
Open days: yes
Technical Bulletins: yes
Update Schedule: yes
Visiting: yes

I hope it is a positive answer

Drachsi

Is This A Good Question/Topic? 0
  • +

Replies To: Email as text file into csv format

#2 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6968
  • View blog
  • Posts: 31,958
  • Joined: 10-May 07

Re: Email as text file into csv format

Posted 27 February 2011 - 12:36 AM

Read the file into an array, translate the carriage return line feed to comma, & then at the end of the file add a carriage return line feed & dump the output to a new file.
Was This Post Helpful? 0
  • +
  • -

#3 Guest_Drachsi*


Reputation:

Re: Email as text file into csv format

Posted 27 February 2011 - 02:08 AM

View Postno2pencil, on 27 February 2011 - 12:36 AM, said:

Read the file into an array, translate the carriage return line feed to comma, & then at the end of the file add a carriage return line feed & dump the output to a new file.


I am completly out of my depth. Sounds like you have my solution, but how do I read the file into an array, and what does it mean? Then Translate etc ,no idea etc.

Regards

Drachsi
Was This Post Helpful? 0

#4 no2pencil   User is offline

  • Professor Snuggly Pants
  • member icon

Reputation: 6968
  • View blog
  • Posts: 31,958
  • Joined: 10-May 07

Re: Email as text file into csv format

Posted 27 February 2011 - 02:34 AM

It's nearly impossible to answer the question without knowing what coding language &/or platform you are trying to do this with.
Was This Post Helpful? 0
  • +
  • -

#5 Guest_Drachsi*


Reputation:

Re: Email as text file into csv format

Posted 27 February 2011 - 02:38 AM

View Postno2pencil, on 27 February 2011 - 02:34 AM, said:

It's nearly impossible to answer the question without knowing what coding language &/or platform you are trying to do this with.

I use Windows 7 and managed to convert all the emails to a text version as above. Now I'm stuck.

Regards

Drachsi
Was This Post Helpful? 0
Page 1 of 1