filipo
Last Activity: Feb 4 '08, 04:10 AM
Joined: Jan 5 '08
Location: Dallas, TX
-
Unless you really enjoy tinkering.... -
So much for my education in Perl... give a man a fish...
Seriously though - before I posted here I didn't even have Perl installed on my machine. Much more to learn.
Cheers,
OmarLeave a comment:
-
Works!
The script was missing
but there were no errors reported even after fixing it. Pretty cool!Code:open ERROR, ">", $errors or die "$!";
Kevin, I really appreciate your assistance. Well, not so much "assistance " but work since you did everything.
Cheers,
OmarLeave a comment:
-
Another issue I've noticed: There are topics that come up like this:
seats
..
seats
..
Re: seats
Re: seats
..
seats
The first two without an "Re:" received separate topic_id's, the two "Re: seats" topics did not receive a topic_id, and the third "seats" without an "Re:" received yet a third topic_id.
Like this:15063 seats...Leave a comment:
-
Kevin, thank you! This is awesome and there is no way I could have done this myself.
It works but because the infile isn't perfect, the outfile suffers.
It seems there are some posts missing at the beginning of the original file, so for some subjects, the first occurrence begins with an "RE:"
How would I set it up so that a first unique Subject receives a new topic_id regardless if it has a RE:...Leave a comment:
-
No. If I understand the question correctly...
For example, there may be a subject "Wings" in January of 1999 with several follow-ups of "RE: Wings", and then an unrelated discussion in December 2003 also with the subject "Wings" and its follow-ups.
However, this is rare and I'm willing to live with these cases being lumped into the same discussion.
Was that the question?...Leave a comment:
-
Anywhere; it can be at the end of each line, for example.
Or it can be in a separate output file and I can later simply add this file as a column in Excel to the existing csv file, as long as that output file is in the same sort order as the original csv and each topic_id is on a separate line. I know it's not an elegant solution, but it would work.
However, if somehow a row got skipped and at the end there are 30,000...Leave a comment:
-
Is this possible in Perl? Mail archive data manipulation
Hello all;
I have a .csv file that contains messages exported from one discussion forum that I want to import into another forum (phpBB), but I need to do some data manipulation on the original export file first.
The original .csv file contains a subject or topic field on each line. Subsequent lines contain replies and other subjects. The file is in chronological order.
Here is a sample layout:
...
No activity results to display
Leave a comment: