Link to home
Start Free TrialLog in
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
Avatar of James0628
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
Avatar of 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
Avatar of James0628
James0628

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial