Search results for query: *

Yes is it is a new topic,but lbass requested data so I included it for convenience. Thanks again to all for the help.

I have split the code into modules and that solved the problem of crashing, and I also created a new report with the new code and both seem OK, except the results are not the same as using the 'full' version of the code, so I assume a mistake has been made in making the modules. Briefly, the...

Thanks, I'll try that. By 'crash', I mean Crystal closes and the Windows error regarding sending an error report appears. I am running XP Pro, incidentally.

Using the following formula in Crystal 8.5 causes the program to crash. Does anybody have a solution? ToNumber( (if Left({Table1.Field1},1) in ["H"] then {Table1.Field1} [2 to 5] else if Left({Table1.Field1},1) in ["U","F"] then {Table1.Field1} [2 to 4] else ToText( if (Val ( strreverse...

That's great, thanks

The strings typically start with either a non numeric or a numeric and end with a non numeric

Our data entry is not consistent and contains fields such as 'H1345' and '1345/'. How can I separate the numeric parts to yield '1345' in both cases?

Thanks for that - very helpful. One more question - is there a way to separate numeric parts in a string, ie to separate '3456' from H3456/P?

I have just reinstalled Crystal V7 and the 8.5 upgrade to my new laptop, but the help files did not install. I looked on both CDs but cannot find them - any ideas?