Parse number from a string 2

[hallux]

Hi everybody,

Is there a Crystal function useful to extract the numbers from a string? The field has a room name followed by a room number "Dining Hall 01". All that is needed is the number "01".

Thanks,
Hallux

 

[lbass]

If the room number is always two digits, you can use:

right({table.string},2)

If the number can vary in length, then try this:

right({table.string}, len({table.string})-instrrev({table.string}, " &quot)

-LB

 

[crystalreporting]

..and if you want to convert the output of lbass's formula to a number - use;

ToNumber({table.string,2)

Crystal will error out when the report is processed if any record has a value that cannot be converted to a number. To avoid this use;

if NumericText({table.string,2}
then
ToNumber({table.string,2}
else
0

Peter Shirley

http://www.linkcorp.com

 

[hallux]

Thank you lbass for a formula that worked perfectly for this situation and crystalreporting for a helpful tip w/ a method of checking for Numeric Text.
-Hallux