Avatar of smit bhavsar
smit bhavsar
 asked on

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

Avatar of undefined
Last Comment
James0628

8/22/2022 - Mon
James0628

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

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

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