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
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