Separating parts of a string 1

[SteveW99]

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?

 

[Naith]

Do you have any instances with non-numeric strings at both the beginning and the end of the field, and numbers you want to extract inbetween?

 

[SteveW99]

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

 

[Naith]

If Val({YourField}) = 0
Then 
CDbl(StrReverse(ToText((Val(StrReverse({Your.Field}))),0,"")))
Else Val({Your.Field})

 

[SteveW99]

That's great, thanks