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 ;)
|