Help convert single column address list into | pipe delimite

General questions about using TextPad

Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard

Post Reply
steve1040
Posts: 39
Joined: Fri Oct 13, 2006 2:19 am

Help convert single column address list into | pipe delimite

Post by steve1040 »

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
User avatar
MudGuard
Posts: 1295
Joined: Sun Mar 02, 2003 10:15 pm
Location: Munich, Germany
Contact:

Post by MudGuard »

Step 1: replace

Code: Select all

([^*])\r?\n([^*])
by

Code: Select all

$1|$2

Step 2: replace

Code: Select all

^|
by nothing
Step 3: replace

Code: Select all

\*+\n
by nothing
ak47wong
Posts: 703
Joined: Tue Aug 12, 2003 9:37 am
Location: Sydney, Australia

Post by ak47wong »

I think ben_josephs was waiting to see if steve1040 was ever going to respond in his other thread 8)
User avatar
woho
Posts: 100
Joined: Tue Sep 02, 2003 9:12 am
Location: Steyr/Austria
Contact:

Post by woho »

:D
Post Reply