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
Help convert single column address list into | pipe delimite
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
Step 1: replace by
Step 2: replace by nothing
Step 3: replace by nothing
Code: Select all
([^*])\r?\n([^*])
Code: Select all
$1|$2
Step 2: replace
Code: Select all
^|
Step 3: replace
Code: Select all
\*+\n
I think ben_josephs was waiting to see if steve1040 was ever going to respond in his other thread 8)