karthikgmkk
New Member
- Joined
- Jul 18, 2015
- Messages
- 13
Hi,
I have values like below, where I have to extract the last part of the string in every value.
It would be great if you also can provide the formula for extracting 2 part of the string as well.
[TABLE="width: 314"]
<colgroup><col></colgroup><tbody>[TR]
[TD]topnav-_-whatsnew-_-topbar[/TD]
[/TR]
[TR]
[TD]topnav-_-whatsnew-_-thisweek[/TD]
[/TR]
[TR]
[TD]topnav-_-designers-_-designera-z[/TD]
[/TR]
[TR]
[TD]topnav-_-clothing-_-dresses[/TD]
[/TR]
[TR]
[TD]topnav-_-sale-_-topbar[/TD]
[/TR]
[TR]
[TD]topnav-_-sale-_-clothing[/TD]
[/TR]
</tbody>[/TABLE]
Can you please help me with the formula?
Regards,
Karthik
I have values like below, where I have to extract the last part of the string in every value.
It would be great if you also can provide the formula for extracting 2 part of the string as well.
[TABLE="width: 314"]
<colgroup><col></colgroup><tbody>[TR]
[TD]topnav-_-whatsnew-_-topbar[/TD]
[/TR]
[TR]
[TD]topnav-_-whatsnew-_-thisweek[/TD]
[/TR]
[TR]
[TD]topnav-_-designers-_-designera-z[/TD]
[/TR]
[TR]
[TD]topnav-_-clothing-_-dresses[/TD]
[/TR]
[TR]
[TD]topnav-_-sale-_-topbar[/TD]
[/TR]
[TR]
[TD]topnav-_-sale-_-clothing[/TD]
[/TR]
</tbody>[/TABLE]
Can you please help me with the formula?
Regards,
Karthik