Use of substring

[Malikto]

I have a field with 15 digits that I need to group by the first 3 digits only.&nbsp;&nbsp;Can someone help me with the formula for this?&nbsp;&nbsp;I believe I need to create a substring to group by but do not know how to do it.<br><br>Thanks

 

[AAP]

Probably easiest to create a formula field (Insert/Formula field/New)where the formula is something like:<br><br>LEFT({datasource.fieldname},3)<br><br>Then group by the formula field.

 

[mns9939]

How can i get 3 digits out of a 13 digit number? The 3 digits i need are in the middle.
For ex; 0758830111999
In this case, i need only 111.
how can i do it? there is no substring function in Crystal Reports.

Thanks

 

[NataleeP]

Try this:

Mid({datasource.fieldname},8, 10)