Extract a String of 9 and or 8 digits

[messier]

Hi there,


i have a column called Remarks with example below:

REMARKS
-----------------
A#457895674:ABC
A#456735674,Affff
A#70673564,Afeefff
AY#126734674;ABC
AA#456235674,ABC

As you can see, the numbers may not always start on the 3rd Char and it may end off with a "," ":" or ";"
how do i just pull the numbers out? (Could be 8 or 9 digits.)

[CJ_London]

perhaps something like

val(mid(myfield,instr(myfield,"#")))

e.g.
?val(mid("A#457895674:ABC",instr("A#457895674:ABC" ,"#")+1))
457895674
?val(mid("A#70673564,Afeefff",instr("A#70673564,Af eefff","#")+1))
70673564
?val(mid("AY#126734674;ABC",instr("AY#126734674;AB C","#")+1))
126734674

note that if the number can start with a zero - then it is not a number, it is a string

?val(mid("AY#026734674;ABC",instr("AY#026734674;AB C","#")+1))
26734674
so depends if you mean a number