| Author | Message | 
| judyp Member
 Joined: 14 Jul 2008
 Posts: 22
 
 | # Posted: 24 Aug 2008 17:47 Reply
 
 Can somebody tell me what to do with a text file of leads that is formatted like this:
 
 "Susan","Somebody","[email protected]","136 Maple St","Anytown","US","00000","","7/26/2008 8:37","","","","","157.42.667","","","","","","","","",
 
 What do I need to get the email addresses out of the text file and into my email list?
 
 __________________
 
 
 | 
| Vishal P. Rao Administrator
 Joined: 23 Jun 2005
 Posts: 782
 
 | # Posted: 25 Aug 2008 09:06 Reply
 
 You can easily import the data into a spreadsheet application like MS Excel.
 
 Data > Import External Data > Import Data
 
 I'm not sure but you might be able to do it using Open Office too (free).
 
 __________________
 
 | 
| Newbie Shield Preferred Member
 Joined: 22 Sep 2007
 Posts: 967
 
 | # Posted: 25 Aug 2008 10:33 Reply
 
 Hi Judy,
 
 It looks like one of two things to me:
 
 1. A generic sample rather than information about an individual.
 
 2. An encrypted file.
 
 If it is a generic sample file, it's worthless.
 
 If it is an encrypted file, you may have to port to a program that can read and translate encrypted information. You'll have to do a Google search to see what serves your budget and technical expertise.
 
 Sounds to me like something no one should be messing with. I recommend against tampering.
 
 Careful what you crack (media thinks it's "hack") as there may be legal consequences.
 
 ~Newbie Shield~
 
 __________________
 
 HTML Squidoo TricksSquidoo-specific HTML how to tutorials, tips and tricks to make your lens stand out from the crowd. Code samples and step-by-step all the way through. 100% free. Made by yours truly ;) | 
| pcwork Member
 
 Joined: 12 Aug 2006
 Posts: 1415
 
 | # Posted: 26 Aug 2008 03:05 Reply
 
 Contact the company providing the leads, they should be able to help
 
 __________________
 
 | 
| judyp Member
 Joined: 14 Jul 2008
 Posts: 22
 
 | # Posted: 26 Aug 2008 03:11 Reply
 
 I don't have a spreadsheet but I found out somewhat by accident that I can import the file into Outlook Express.  Thanks for all the responses!
 
 __________________
 
 | 
| Newbie Shield Preferred Member
 Joined: 22 Sep 2007
 Posts: 967
 
 | # Posted: 30 Aug 2008 13:50 · Edited by: Newbie Shield Reply
 
 Judy,
 
 You can download Open Office for free and use their spreadsheet program. It's similar to MS Excel. Your file could very well be a CSV file. In that case, it will open in a spreadsheet program.
 
 It would be more useful in a spreadsheet program than in MS Outlook Express. You can play around with it quite a bit in the spreadsheet program.
 
 Let us know if it works and good luck,
 
 ~Newbie Shield~
 
 __________________
 
 HTML Squidoo TricksSquidoo-specific HTML how to tutorials, tips and tricks to make your lens stand out from the crowd. Code samples and step-by-step all the way through. 100% free. Made by yours truly ;) |