get only number from string and find sum in crystal report formula

hello everyone
i want one help from you that

example : i have one database field it contain some value like

1) abc-100,abc2-110,defa-200,xyzx-10
2) abcd-100,abc1-110
3) xyza-10,zzz1-150
4) pqrs-50,
5) pppzab-150,pabc-150

i want answer like
1)420
2)210
3)160
4)50
5)300

i hope u all are understand and help me to solve that problem in crystal report
please help me friends i am new for crystal report so please
thanks

thanks
and regards smit

Crystal Reports

Last Comment

James0628

8/22/2022 - Mon

James0628

10/22/2015

Based on what you posted, I don't think this will be too difficult, but I don't have time to get into it right now. I also wanted to check some things.

Will the values in the field (eg. "abc-100" and "defa-200") always be separated by commas?

Is the number that you're interested in always at the end of each substring, and always after a "-"?

If the answer to those questions is "yes", I don't think it will be a problem. I'll post something later, if someone else doesn't beat me to it. :-)

James

smit bhavsar

10/22/2015

ASKER

hello jeams
yes you r right value separate by comma and there's underscore between number and string
if u have any idea about this question answer then plz reply me the answer because i have no idea about crystal report so please help me

thanks
smit

ASKER CERTIFIED SOLUTION

James0628

10/22/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck