• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

How do I do a search and replace in Crystal Syntax?

I am looking to get a search and replace at a specific location in Crystal Syntax.  I have a database spitting out records stating 01/11/A6, but I want to be able to convert 01/11/A6 to a date that says 01/11/06.  Can anybody help me please?  
0
VBBRett
Asked:
VBBRett
  • 2
1 Solution
 
VBBRettAuthor Commented:
anybody have the answer?
0
 
frodomanCommented:
Replace({YourDatabaseField},'/A6','/06')

This formula will return the original field value but replace the A with a zero.  Is that what you're looking for?
0
 
VBBRettAuthor Commented:
Yes, thank you.  I think i was looking for the following

Replace({YourDataBaseField}, '/A', '/0')

But thanks anyway.  500 points for you!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now