[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2006-07-12
3
Medium Priority
?
351 Views
Last Modified: 2008-03-06
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
Comment
Question by:VBBRett
  • 2
3 Comments
 

Author Comment

by:VBBRett
ID: 17093640
anybody have the answer?
0
 
LVL 42

Accepted Solution

by:
frodoman earned 2000 total points
ID: 17093712
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
 

Author Comment

by:VBBRett
ID: 17093811
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question