Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 204
- Office Version
- 365
- Platform
- Windows
Hi, Thank you for taking a moment to read this -
I would like to separate the street number from the street name
Criteria for Separation - From LEFT, Separate at NUMBER
Example [TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Wentworth Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Vil18 1 Monty Pl[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Unt17/23/ Chave St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Unit82 98 Corinna St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]8 Rischbieth Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]13 Mt Warning Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]45Cuthbert[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Rm103 35 Bonney St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Rm1111 Carnegie Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Post Separation
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Wentworth Ave[/TD]
[/TR]
[TR]
[TD]Vil18 1[/TD]
[TD]Monty Pl[/TD]
[/TR]
[TR]
[TD]Unt17/23[/TD]
[TD]Chave St[/TD]
[/TR]
[TR]
[TD]Unit82 98[/TD]
[TD]Corinna St[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Rischbieth Crs[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Mt Warning Crs[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]Cuthbert[/TD]
[/TR]
[TR]
[TD]Rm103 35[/TD]
[TD]Bonney St[/TD]
[/TR]
[TR]
[TD]Rm1111[/TD]
[TD]Carnegie Crs[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would like to separate the street number from the street name
Criteria for Separation - From LEFT, Separate at NUMBER
Example [TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Wentworth Ave[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Vil18 1 Monty Pl[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Unt17/23/ Chave St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Unit82 98 Corinna St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]8 Rischbieth Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]13 Mt Warning Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]45Cuthbert[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Rm103 35 Bonney St[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 278"]
<tbody>[TR]
[TD="width: 278"]Rm1111 Carnegie Crs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Post Separation
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Wentworth Ave[/TD]
[/TR]
[TR]
[TD]Vil18 1[/TD]
[TD]Monty Pl[/TD]
[/TR]
[TR]
[TD]Unt17/23[/TD]
[TD]Chave St[/TD]
[/TR]
[TR]
[TD]Unit82 98[/TD]
[TD]Corinna St[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Rischbieth Crs[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Mt Warning Crs[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]Cuthbert[/TD]
[/TR]
[TR]
[TD]Rm103 35[/TD]
[TD]Bonney St[/TD]
[/TR]
[TR]
[TD]Rm1111[/TD]
[TD]Carnegie Crs[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Last edited: