Extract non-adjacent digits from a string

[Ports]

Hi,


I've got a field with records as follows:
17/18RO
18/19RO
17/18RO
16//17RO


It's all consistent: 2 digits / 2 digits RO


I'm trying to extract just 1718 or 1819 or 1617 in a query (basically the 4 digits)


I've tried val([field]) but it only returns the first 2 digits.


Please advise. Thank you

 

[deletedT]

Use this one:

Val(Replace([field], "/", ""))

 

[Ports]

Lovely. Thank you.

 

[Galaxiom]

Note that Val() returns a number so any leading zeros will be dropped.
If this matters you can use this which will return a string:

Left([field],2) & Mid([field],4,2)