record grouping

[vertcnc]

I would like to group a series of part#'s by the prefix of the part #. The format of the records are similar to this.
1111-222-3s-3s, 1111-222-4s-4s, etc. I am looking to group these records based on the characters proceding the first dash.
Any help would greatly be apprciated.

Thanks

 

[groggle]

Create a formula as per the following:

{PartNumberField}[1 to 4] if the first segment of the part number is always four characters or {PartNumberField}[1 to instr({PartNumberField},"-")-1] if the length of the first segment varies.

Then insert a Group on this formula field.

 

[vertcnc]

Thanks, I will give that a try.

 

[vertcnc]

Ok, That works great. Now say the some segments are divided by a "X" instead of a "-" could I put a what if type statement to either look at the "-" or the "x". For part numbers that have "-" I am adding a suffix to the grouping name such as "X-X-S" and for the "x" i would like to add a different suffix.
Thanks for the help.