Getting Rid of a Comma in Crystal Expression

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
BrockAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this

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

Another way would be

Mid({NCHR4050B.COURSE_DESCR},2)

mlmcc
0
 
BrockAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.