Help convert single column address list into | pipe delimite
Posted: Thu Oct 26, 2017 8:58 am
I have text formatted like this
**********
Errick Smart
8707 West Placestreet Dr
Apt 202
Little Rock, AR 72204
501-898-4729
**********
Rev. Leotis James
7210 Miltor Dr
North Little Rock, AR 72209
555-123-4823
**********
Rev. Korey Foreman
813 W Nameit St Apt 2
West Memphis, AR 23014
**********
Mulanda & Jeff Farr
2515 Faye St
Desoto, TX 75115
123-397-0215
**********
Fae & Sherbert McCoy
9933 Dethel Blvd
Zion, IL 60099
847-409-1234
**********
Bettye Western
PO Box 8676
Moro, AR 72368
870-999-0977
**********
Mactha Ritchell
7777 E. 40th Place
Kansas City, MO 64130
816-861-7777
**********
Karen Miller
2001 AStreet Layne Ct
Sherwood, AR 72120
501-835-9999
501-351-9999
**********
Marvella & Sharon Smarr
708 Thisstreet Way
Marianna, AR 72360
870-295-9999
**********
Latonya James Gipson
1234 Anystreet Ln
Garland, TX 75043
999-293-9999
**********
How can I extract each address between ********** into a pipe delimited row.
Name|address1|address2|City|State|Zip|Phone1|Phone2
Thanks
Steve
**********
Errick Smart
8707 West Placestreet Dr
Apt 202
Little Rock, AR 72204
501-898-4729
**********
Rev. Leotis James
7210 Miltor Dr
North Little Rock, AR 72209
555-123-4823
**********
Rev. Korey Foreman
813 W Nameit St Apt 2
West Memphis, AR 23014
**********
Mulanda & Jeff Farr
2515 Faye St
Desoto, TX 75115
123-397-0215
**********
Fae & Sherbert McCoy
9933 Dethel Blvd
Zion, IL 60099
847-409-1234
**********
Bettye Western
PO Box 8676
Moro, AR 72368
870-999-0977
**********
Mactha Ritchell
7777 E. 40th Place
Kansas City, MO 64130
816-861-7777
**********
Karen Miller
2001 AStreet Layne Ct
Sherwood, AR 72120
501-835-9999
501-351-9999
**********
Marvella & Sharon Smarr
708 Thisstreet Way
Marianna, AR 72360
870-295-9999
**********
Latonya James Gipson
1234 Anystreet Ln
Garland, TX 75043
999-293-9999
**********
How can I extract each address between ********** into a pipe delimited row.
Name|address1|address2|City|State|Zip|Phone1|Phone2
Thanks
Steve