Import memo style text?

  • Thread starter idmnstr via AccessMonster.com
  • 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
 
J

John Nurick

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).
 
I

idmnstr via AccessMonster.com

John,

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

Regards,
Jim
 
Top