convert from column to row

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

joeweb

convert from column to row

Postby joeweb » Thu Jul 22, 2004 9:40 am

Hi,

it seems that I found the tool that could make my life easier, but at the moment I'm not sure which is right way to use it.

I need to import the textfile from a "former" outlook pst file into a separate database. So far I was able to convert the pst to a txt file. But the layout of this txt is in rows insted of columns. In this way I can not import the data properly. So I'm looking for a solution to "convert" the data.

This is what it looks like at the moment (with several 100 mails in one file)

e.g.
From [no data]
From: [no data]
To: [no data]
Subject: Messaggi
Sent: [no data]
Date:
X-Folder: Posta eliminata
X-Text: 1
here we see the conten of the mail.
the lenght of this text is different in each mail.
some short, some long


From [no data2]
From: [no data2]
To: [no data2]
Subject: Messaggi2
Sent: [no data2]
Date: 12.12.12
X-Folder: Posta eliminata
X-Text:
another text

and so on....


should look like:
From | From | To: | Subject: | Sent: | Date: | X-Folder: | X-Text: |
mail1 a@b xx abc 12.12. vv posta blabla
mail2 a@b xx abc 13.12. vv posta blabla


any idea for me how to start that action?


regards,

Joe

User avatar
DataMystic Support
Site Admin
Posts: 2136
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Wed Sep 14, 2005 3:17 pm

Can't you just search/replace the \r\n characters to a | pipe character?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest