-
seperate names
l would like to separate the surname from the initial and the residentialaddress.
The records looks like this
NAME
----------
stanley MS
Johnson NP
Roberts NE
VE Jones
VD Maiden
Miller I
KOBANE M
RESIDENTIAL
--------------
matatiele,4730
mamakato,3310
kokstad,4700
Flagstaff,4810
riverside,3239
Silverton,4360
Donesdale,1600
The problem is that sometimes the surname has the initials in the same column.The order can be initials then surn or surn then initials.
My second problem is to separate the residential into area and postalCode.
Last edited by sleezy; 11-20-2002 at 03:17 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|