extracting number from string

[CDCOV]

Hi

I have recently started using crystal 9

I am trying at the moment to extract a number reference from a mixed character number field There may be characters both before or after the number or not at all?

Secondly having got a list of numbers I need to order them incrementally so that 2 follows 1 etc.

can anyone tell me how to achieve this ( in simple terms)


Chris

 

[lbass]

Create a formula to place in the details section:

whileprintingrecords;
numbervar counter;
stringvar x := "";

for counter := 1 to len({table.string}) do(
if isnumeric({table.string}[counter]) then x := x + {table.string}[counter] else
x := x);
val(x)

Substitute your field for {table.string}. The result will be a number which will sort accurately.

-LB