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 Chriss Miller 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
Joined
Mar 6, 2007
Messages
17
Location
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 Question
Crystal Report
Replies
2
Views
800
john432
john432
john432
  • Locked
  • Question Question
Crystal Report Help
Replies
2
Views
752
john432
john432
mmck1964
  • Locked
  • Question Question
Using "OR" to select data
Replies
4
Views
988
mmck1964
mmck1964
D
  • Question Question
Dynamic field height in crosstab?
Replies
0
Views
153
doodledump
D
john432
  • Locked
  • Question Question
Crystal Report formula (finding with key words)
Replies
2
Views
728
john432
john432

Part and Inventory Search

Sponsor

Back
Top