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

using substring in crystal

Status
Not open for further replies.
shricky

shricky

Programmer
Mar 6, 2007
17
US
how do i turn this into a crystal function?
SUBSTR (col.user_1, INSTR (col.user_1, '.') + 1)

I am asking it to find the . (10.34009) and return the 34009.
 
Sort by date Sort by votes
Try:

mid({col.user_1},instr({col.user},".")+1)

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

john432
  • Locked
  • Question
Crystal Report
Replies
2
Views
204
john432
john432
john432
  • Locked
  • Question
Crystal Report Help 1
Replies
2
Views
207
john432
john432
mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
318
mmck1964
mmck1964
john432
  • Locked
  • Question
Crystal Report formula (finding with key words) 1
Replies
2
Views
244
john432
john432
sofseattle
  • Locked
  • Question
Crystal formula for barcode display shows extra characters in date format?
Replies
1
Views
198
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top