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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strings 1

Status
Not open for further replies.
deeya

deeya

MIS
Sep 18, 2006
78
GB
Hi,

CR11

How would I just extract "Connaughty" from the string below?

"Nortel Ethernet Routing Switch 5510-24T Module - Port 9 - Connaughty"

Many Thanks
 
Sort by date Sort by votes
you could try

strreverse(extractstring(strreverse({yourstring}),"","-"))
 
Upvote 0 Downvote
great thanks! never come accross that command.....used instr etc
 
Upvote 0 Downvote
I know that extractstring is not in the list of formulas available when in the in the formula editor. Makes me wonder what else I have missed.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ejastia
  • Locked
  • Question
FILTERING STRINGS
Replies
4
Views
41
ejastia
ejastia
DJWheezyWeez
  • Locked
  • Question
Distinct count of uniquely created strings based on variables
Replies
1
Views
40
DJWheezyWeez
DJWheezyWeez
betachristopher
  • Locked
  • Question
need to convert memo field into dynamic array of <=75 character strings 1
Replies
2
Views
44
betachristopher
betachristopher
NiteClerk
  • Locked
  • Question
Character Long Object - Replace strings
Replies
1
Views
37
CoSpringsGuy
CoSpringsGuy
agorjest
  • Locked
  • Question
Strings with quotation marks 1
Replies
2
Views
108
agorjest
agorjest

Part and Inventory Search

Sponsor

Back
Top