Aggregate projectnumbers

[#1]

Hello can someone help me out?

I've got a projectlist with double numbers i want to aggregate.

For example 12015501 and 12015501-A to make one number together.

[sivarajs · Accepted solution]

Check the attached file

[#3]

Many thanks.

[#4]

Can you helpp me again?

Now i've got different types of projectnumber like, 12015555A and 12014444-A together.

[#5]

Can you helpp me again?

Now i've got different types of projectnumber like, 12015555A and 12014444-A together.

[sivarajs]

How you want to group

12015555A -->12014444-A or

12014444-A --> 12015555A

Because number varying here you need to be clear on that

[#7]

12015555 and 12015555A -> 1201555 and 12014444 and 12014444-A -> 12014444

[sivarajs]

try this if(Right('120555A',1)>0,left('120555A',index('120555A',Right('120555A',1))-1),'')

[#9]

Please check the attachement

[sivarajs]

Try this sample