crystal reports syntax

yes I am using a Group field, I would like to know what is the syntax to read the string so I can group by lets say the first 4 char.

I tryied left(table,4)
did not come out  effective

for instance I have
mottos
mottos
mottos
mottossgs

I want the above to group together by the string above.
LVL 9
Seven priceFull StackAsked:
Who is Participating?
 
mlmccCommented:
Did you create a formula?

   Left({YourField},4)  

That should give you the first 4 characters of the field.

mlmcc
0
 
Seven priceFull StackAuthor Commented:
tkd
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.