Need to group on change of string 1

[boardburner]

CR10
I have to do a listing report on components {IPART.IPPART}in our inventory and I wish to "group" by any change in the first (4)digits in the part number {IPART.IPPART}. The part numbers are strings not an actual number.

Examp: 1004-235, 1004-387, 2000-658, 2001-897, 4002-264, etc. etc.

I wish to end up with group 1:
1004-235,1004-387
I wish to end up with group 2:
2000-658
I wish to end up with group 3:
2001-897
I wish to end up with group 4:
4002-264

Basically when anything changes in the first (4) characters I want to start a new group. This seems simple enough but I have a mind freeze going.

Thanks

 

[Turkbear]

Hi,
Create a formula:

@gstring ( Ok, maybe a bad choice)..

{IPART.IPPART}[1 to 4]

Group on this formula...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[boardburner]

Worked perfect

Thanks