Extracting numbers from a string

[ukleaf]

Hi all,

is there an easy way in Crystal to extract a number from a string?

Basiclly the number within the string will always be set out like this,

String line then number amount - £100.00 -

thanks.

 

[lupins46]

Maybe.

So is the pattern ALWAYS:

xxxxxx...xxxx dash poundsign amount dash

And can it be said that the xxxx..xxxx will NEVER contain a dash or a poundsign. Are the amounts ALWAYS positive?

 

[ukleaf]

Hi there,

Yes the text will always be the same up to the - and the £, just the amounts will vary... there will also be a - after the amount too, e.g.

XXXXXX XXXXXXX .... - £1000.00 -
XXXXXX XXXXXXX .... - £23.00 -
...
...

Thanks

 

[lupins46]

Use this formula, modified with your own tabl/field names.

numbervar vStart;
numbervar vEnd;
vstart:= instr({mytable.myfield},"£");
vend := instr(vstart,{mytable.myfield},"-");
mid({mytable.myfield},vstart,vend-vstart)

 

[ukleaf]

Great, thanks very much. I'll give it a try and let you know.

Thanks again.

 

[bdreed35]

You could also use something like this if you want the "£" included:

split({table.field},"-")[2]


If you don't want the "£" included, this should work for you:

val(split({table.field},"-")[2])

~Brian