?
Solved

Getting Rid of a Comma in Crystal Expression

Posted on 2008-11-17
2
Medium Priority
?
199 Views
Last Modified: 2012-05-05
I would like to get rid of the first comma appearing in this string.  

It looks like   ,Math101, Math102, Math103

Here is the code:

Report Header area:
WhilePrintingRecords;
global stringvar STRING1;
STRING1=""

Details Area:
WhilePrintingRecords;
global stringvar STRING1;
STRING1:=STRING1 & "," &  {NCHR4050B.COURSE_DESCR};

Footer (Display)
WhilePrintingRecords;
global stringvar STRING1;

****I have tried replace but it gets rid of all the comma's *****

Any help would be greatly appreciated.

Lucy
0
Comment
Question by:Lucia
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 22978280
Try this

Replace({NCHR4050B.COURSE_DESCR},',',1)

Another way would be

Mid({NCHR4050B.COURSE_DESCR},2)

mlmcc
0
 

Author Comment

by:Lucia
ID: 22978679
Hi mlmcc,

I had problems with where I was putting the formula.  It should have been in the display area not the details.

Thanks for your help,
Lucy
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
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…
Suggested Courses
Course of the Month16 days, 1 hour left to enroll

850 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