Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How I can Extract Right Side of a Field

Status
Not open for further replies.

gotluru

Programmer
Oct 16, 2000
10
US
Hi,

When I use Unstring I able to get 1 Yrs 11 for months, how i can extract 11 from there.

Ex: Test unstring of: 1 Yrs 11 Months 3 Days 1 Rightmost digits(if any) are years 1 Yrs 11 Rightmost digits(if any) are months 1 Yrs 11 Months 3 Rightmost digits(if any) are daysTest unstring of: 10 Days 1 Months 100 Yrs 10 Days 1 Months 100 Rightmost digits(if any) are years 10 Days 1 Rightmost digits(if any) are months 10 Rightmost digits(if any) are daysTest unstring of: 9Months1Day1Yr 9Months1Day1 Rightmost digits(if any) are years 9 Rightmost digits(if any) are months 9Months1 Rightmost digits(if any) are daysTest unstring of: 1 Month 7 Days Rightmost digits(if any) are years 1 Rightmost digits(if any) are months 1 Month 7 Rightmost digits(if any) are daysTest unstring of: 27Days Rightmost digits(if any) are years Rightmost digits(if any) are months 27 Rightmost digits(if any) are days

Thanks
 
Hello gotluru

Please, can you expose you source code correctly?
Then explain better what you need....

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top