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!

search and replace field?

Status
Not open for further replies.
MJ1299

MJ1299

Programmer
Joined
Nov 28, 2000
Messages
5
Location
CA
Hi,

I have a varchar field that is passed to my report. I want to create a formula that parses the string for a certain character and replaces it with another when it finds it.

Any ideas on how to do this?

Thanks!
MJ
 
Sort by date Sort by votes
use this function:

Replace (input string, findstring, replacestring)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

smmt2207
  • Locked
  • Question Question
Text field formula help
Replies
1
Views
697
hilfy
hilfy
H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
401
DjangMan
DjangMan
M
  • Question Question
ODBC vs ADO incorrectly defining fields
Replies
4
Views
360
mavrick5au
M
David Richardson
  • Locked
  • Question Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
1K
hilfy
hilfy
Ajmal N
  • Locked
  • Question Question
Compare a field from main report against a field from a subreport on CRYSTAL REPORT
Replies
7
Views
726
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top