🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

how to get the data between two tags

User: "sukh"
New Altair Community Member
Updated by Jocelyn
hi everyone,
i have a text file:




<DATE>08/05/2007</DATE>
<AUTHOR>SS</AUTHOR>
<TEXT>We have only had the Edge for 3 weeks and 1200 clicks but so far we are very impressed. The handling, comfort and ride is excellent. I don't think we could of picked a better all around driver.</TEXT>
<FAVORITE>Vista Roof (BAMR)and great rear seat room. I read the reviewers complaints about no third row seat. If it had one we would not of bought it. It is a sporty people mover with style. The handling is superb and very confident. I like the balance between ride and handling - Ford nailed this one!</FAVORITE>
</DOC>
<DOC>
<DATE>08/04/2007</DATE>
<AUTHOR>autofan2</AUTHOR>
<TEXT>Spent 3 months looking for CUV. Tried the Edge, CRV, RAV4, Pilot, Outlander, VUE, CX-7, & CX-9. Came down to the CX- 7 & the Edge. After driving them back to back, the Edge came out on top. Not as "sporty", but V-6 feels stronger than the Turbo 4 & burns regular. Vista Roof is incredible. It's like having a convertible CUV. Nav & Sound system are great, along with SIRIUS. Got Black/Black with the 18" chrome wheels...fantastic looking vehicle just adds to great driving experience. Contrary to a magazine review I read, brakes work very well. I may even buy a few shares of Ford stock - the Edge is that good. Great follow-up to the Fusion/Milan/MKZ. Proves they can build best-in-class autos.</TEXT>
<FAVORITE>NAV, Audio, & Sirius. Seat position is perfect; good lumbar & nice to have telescoping wheel, too. Flex seating opens up a lot of cargo space very easily. Exterior design is striking - neighbors thought it was luxury import. V-6 & 6-sp tranny are smooth, powerful, and take regular. Many others.</FAVORITE>
</DOC>
<DOC>
<DATE>07/23/2007</DATE>
<AUTHOR>Trajan265</AUTHOR>
<TEXT>I have owned this vehicle for two weeks and, so far, I love it. I had a Volvo XC70 and I prefer the Edge over the Volvo. The overall feel of quality is remarkable. This vehicle is smoother, quieter, and faster than the Volvo and has more room inside. The motor revs freely and pulls hard from a stop, with the help of the close ratio 6-speed automatic.</TEXT>
<FAVORITE>The Edge looks great from all angles and is very comfortable inside. The reclining rear seat is great when riding in the back with our new baby. Plenty of room for all of our stuff. The panoramic roof is awesome!</FAVORITE>
</DOC>



i want to extract date , author and text for each document.
each row contain one document with corresponding, author, text and date.
as i have  used string matching for extracting date and text.but it gives only first document's date, author and text.

Find more posts tagged with