PHP Script to pull info and store in DB or export to excel

I have data that I need to make more organized. Here is an example of the data. Here is an example of three leads below. I need to pull the Name/Address/City/State/Zip/Phone/HHonors Tier for each one below. There are three divided by the dotted line.

676700010 Abdurrahman, Yahya 39/LP /22114 OWS/RR *CKD OUT HGVC RENTER 178.08 178.08

12/28/11 4120 Hudchinson River Prkwy E Start Nts Amount Rate Desc (no acct)

12 ngts Apt #D 12/28 2 159.00 RATE:LV5 2/0 *HS-09/18/11

01/09/12 Bronx, NY 10475 12/30 2 179.00 RATE:LV5 PROMO: 9168 BEST AVL RT:LV5 SAM-12/28/11 *

(718) 320-0756 01/01 5 159.00 RATE:LV5 SOURCE: 9105 BEST AVAILABLE RATE

SUP: NO 01/06 2 179.00 RATE:LV5 [url removed, login to view]: 22 HILSTAR DIRECT BOOKING

HHonors Tier: Blue 01/08 1 159.00 RATE:LV5 LEADNO: 10-2455572

------

Tx:238.56 2226.56 Stay Total

-------------------------------------------------------------|-----------------||---------------|-----------------------------------

668857610 Abiad, Ernest A. 37/LP /0517 CLB/CB *CKD OUT CLUB 0.00 0.00

12/28/11 ABIAD, ARLENE M. (no acct)

6 ngts 5049 Bella Collina St 3/0 JAS-08/08/11

01/03/12 Oceanside, CA 92056-1924 PROMO: 4100 $100 CASINO CHIPS SGL-12/29/11 *

(760) 643-1510 SOURCE: 1050 OWNER PROGRAMS

SUP: NO [url removed, login to view]: 25 OWNER PROGRAMS

TOUR DATE: 01/01/12 OFFICE: 32 OPERATOR: 1665 MORTEL, ANGELIE LEADNO: 10-277135

HHonors Tier: Silver

-------------------------------------------------------------|-----------------||---------------|-----------------------------------

671035110 Acklin, Frederick 39/2LO/11419,11421 CLB/CB *CKD OUT CLUB 0.00 0.00

12/28/11 ACKLIN, SALLYANN (no acct)

6 ngts 17131 Alexandra Cir 4/0 CHH-08/18/11

01/03/12 Cerritos, CA 90703-1036 PROMO: 211 SITE ECU-12/28/11 *

(562) 926-9994 (562) 500-9994 SOURCE: 8034 HGVC AT FLAMINGO HILTON LAS VEGAS

SUP: NO [url removed, login to view]: 96 HORIZONS

TOUR DATE: 03/17/12 OFFICE: 48 OPERATOR: 20167 ROMAN, IRIS LEADNO: 34-3709

HHonors Tier: Silver

PHP

ID Proiect: #1615842

Detalii despre proiect