Import memo style text?

  • Thread starter Thread starter idmnstr via AccessMonster.com
  • Start date Start date
I

idmnstr via AccessMonster.com

Hi,

I have an email in Outlook that contains data delimited by a colon (:). The
problem is that the data in in Memo style and not tabular. One email should
be a row/record. All the column names are in the email to the left of the
colon and the data is on the right. an example would be;

First Name: Jim
Last Name: Brown

Address: 123 East Broadway Street
Anytown, NH 03060

Any Hints would be helpful!

Regards,
Jim
 
Hi Jim,

Assuming that this is a one-off (you mention "an email") I'd do this
by pasting the relevant part of the email into a text file.

Then I'd use the "TaggedLineToDelim.pl" script on my web page at
http://www.j.nurick.dial.pipex.com/Code/Perl/index.htm to convert it
to an ordinary CSV file. (This requires that you have or install Perl
on your computer.)

Otherwise I think it's a matter of writing custom code in VBA or your
favourite programming language or using commercial software (Monarch
or TextPipe are the ones I'd look at first).
 
John,

Thank you for your response. The problem is that I do not have Pearl
available to me.

Regards,
Jim
 
Back
Top