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!

substring type question

Status
Not open for further replies.
q4s72534

q4s72534

MIS
Aug 19, 2003
59
US
i want to pull the first 3 numbers after the "-"

example:
4578477-78434

I want to see "784"

what is the code? i tried this and it didn't work.

fieldName["-",3]


thanks!
 
Sort by date Sort by votes
try fieldName[(index(fieldName,"-",1)+1),3]

or

field(fieldName,"-",2)[1,3]

*this all assumes only a single "-" in fieldName
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

senthil45
  • Locked
  • Question
informatica complex question
Replies
0
Views
89
senthil45
senthil45
donafran
  • Locked
  • Question
Columns Tab question
Replies
1
Views
113
johnherman
johnherman
donafran
  • Locked
  • Question
Data Stage LOG detail question
Replies
2
Views
114
donafran
donafran
btamulis
  • Locked
  • Question
Access 2000 Odbc Query question
Replies
1
Views
65
SkipVought
S
mirogak
  • Locked
  • Question
type conversions
Replies
3
Views
47
blom0344
blom0344

Part and Inventory Search

Sponsor

Back
Top