Strip hyphens from field

[esskaykay]

We have a database tracking construction plans. In most instances the plan number is a 6 character value displayed with hyphens:

Display = 98-12-17
Field Value = 981217

I have a search criteria set as:
=Left([Plan_No],2) & Mid([Plan_No],4,2) & Right([Plan_No],2)

This works fine as long as the plan number is only 6 characters. However, in some instances this is not the case (i.e., 98-12-17A). I could use a IIF and LEN() statement which works in this case. But, to really muddy the waters, there are fewer other non-plan files filed and indexed as example 8C-123.

I’m not positive this is exactly what I want until I play with it a bit, but, is there a way to strip all hyphens from the field Plan_No?

Thanks,
SKK

 

[SOS]

Perhaps use Replace

Replace([YourFieldName], "-", "")

 

[Atomic Shrimp]

Alternatively, I wrote a function called 'allowonly' - which will strip any unwanted characters from a string.

http://www.access-programmers.co.uk/forums/showthread.php?t=165764&highlight=allowonly

 

[esskaykay]

Excellent, I will play with this and let you know.

Thanks again,
SKK

 

[esskaykay]

Just a follow up. Works like a charm.

Thank you...