Group items together by first number even if item has letter before it

[mikeclark82]

Im using crystal reports xi and i am trying to group item numbers together into groups i.e.
group 1 contains all item numbers that start with a 1*
group 2 contains all items that start with a 2* etc

my problem is some item numbers start with a letter but this can be any random number, therefore no matter what the letter I still require it to go into the group by the first number after the letter i.e if it was A102 i would want it to go into group 1 or w298 would go into group2

any replies would be excellent

 

[Madawc]

You need to group by a formula: e.g.

if NumericText(left{your.code, 1)) 
then left{your.code, 1)
else if NumericText(mid{your.code, 2, 1)) 
then mid{your.code, 2, 1)
else if NumericText(mid{your.code, 3, 1)) 
then mid{your.code, 3, 1)

and so on, depending on your data.

Madawc Williams (East Anglia, UK)