I would like to clean up a large file so I can import it into a database.
For each line starting with MV: I want to place
place a | at the end
Delete all but the first plot entry
Remove PL:
Remove BY: line
I can't seem to construct this but I think this is the approach I want
Code: Select all
(^MV: **Anything here** ^BY: \n) **TheTargetstuff** (^BY: \n -) So I need an expression that does something like thisMV: "$1,000,000 Chance of a Lifetime" (1986)
PL: A short-lived quiz show hosted by TV veteran Jim Lange. Husband-and-wife
PL: teams would compete against each other in answering a tough series of
PL: trivia questions. The winning couple would then go on to the championship
PL: round, where they would have a chance to win one million dollars.
BY: Jean-Marc Rocher <rocher@fiberbit.net>
PL: Two married couples, sometimes including a returning champion, competed in
PL: one of the first game shows to offer $1 million as a grand prize. In
PL: "$1,000,000 Chance of a Lifetime," which combined elements of "Wheel of
PL: Fortune" and "Scrabble," the couples competed to solve word puzzles. Up to
PL: six clues were given for the puzzle's solution; one member of each team was
PL: selected to try to guess each clue word, with letters inserted at random
PL: except for the last one. Each correct guess was worth $25 and allowed the
PL: contestant to go to the keyboard. The keyboard indicated which letters were
PL: in the puzzle, plus one "stinger" (an extra letter not in the puzzle);
PL: selecting the "stinger" meant the contestant lost his/her turn, and a new
PL: clue was played. Each selected letter revealed in the puzzle added $25 to
PL: the pot; the team that solves the puzzle won the pot. Three rounds were
PL: played, with the second round values of $50 per clue/puzzle letter and
PL: third round values of $100 each. The team with the most money after three
PL: rounds was champion, kept their winnings and advanced to the bonus round.
PL: In the bonus round, the couple selected a category from a choice of three
PL: and then are locked in an isolation booth. The couple has 60 seconds to
PL: guess six words associated with that category. For each successful bonus
PL: round win, the couple was given a cash prize ($5,000 on day 1, $10,000 on
PL: day 2), or they could give it back and continue, always at risk of losing a
PL: subsequent bonus round and thus having to leave the show. Only by winning
PL: three bonus rounds in a row did the couple win the $1 million grand prize.
PL: The $1 million was awarded as all cash during the spring 1986 season, and
PL: $900,000 plus a $100,000 luxury prize package (two Mazda cars, a house full
PL: of furniture, including a living room, dining room, bedroom, complete
PL: kitchen and outdoor spa, and twenty round-trip airline tickets to anywhere
PL: in America on Delta Air Lines) during the 1986-1987 season.
BY: Brian Rathjen <briguy_52732@yahoo.com> and "Ranger Ian" <ianofrhs@hotmail.com>
-------------------------------------------------------------------------------
Desired Outcome
"$1,000,000 Chance of a Lifetime" (1986)| A short-lived quiz show hosted by TV veteran Jim Lange. Husband-and-wife
teams would compete against each other in answering a tough series of
trivia questions. The winning couple would then go on to the championship
round, where they would have a chance to win one million dollars.