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!

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

How to get the last word from a series and map it. 2

Status
Not open for further replies.
rohitair

rohitair

Programmer
Aug 30, 2011
6
IN
I have a text with /
ex proc/get/lastword
I dont know how many / slashes will be there in the text.
I need to get last word and map it.
Please suggest a sloution.Thanks
 
Sort by date Sort by votes
Use the WORD function...

WORD(Text_Item, "/", -1)

-1 indicates that you want the last instance.

Richard
 
Upvote 0 Downvote
Yes, the '-' means read from the right and 'number' is which delimited word you want.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Audrieharst
  • Locked
  • Question
What are the Uses of APK FILE Extension?
Replies
0
Views
87
Audrieharst
Audrieharst
maltu
  • Locked
  • Question
ITX10.0 to KAFKA topic connection failire
Replies
0
Views
88
maltu
maltu
KitShri
  • Locked
  • Question
Need Help in mapping line levels detaisl in 856 with missing Parent-Child Hirerachy
Replies
0
Views
80
KitShri
KitShri
satish_kumar
  • Locked
  • Question
Need some more documentation for HTTP and HTTPS
Replies
0
Views
95
satish_kumar
satish_kumar
Ram Kumar
  • Locked
  • Question
Can we create Type Tree from XSD file
Replies
0
Views
106
Ram Kumar
Ram Kumar

Part and Inventory Search

Sponsor

Back
Top