Strip Charcter from File Name

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Any advice/suggestions would be appreciated

We have a combo box which lists a list of product categories. On the
AfterUpdate event a query runs which exports all of the selected products to
an Excel file. This is working OK unless there is a \ within the category
name, e.g. label/white.

What would be the best way to strip the / from that string?

TIA
Tom
 
Use Replace() function to replace the slash with an empty string:
Replace([Category], "/", "")
 
Thanks Allen works a treat

Tom
Allen Browne said:
Use Replace() function to replace the slash with an empty string:
Replace([Category], "/", "")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Tom said:
Any advice/suggestions would be appreciated

We have a combo box which lists a list of product categories. On the
AfterUpdate event a query runs which exports all of the selected products
to an Excel file. This is working OK unless there is a \ within the
category name, e.g. label/white.

What would be the best way to strip the / from that string?
Click to expand...
Click to expand...
 
Back
Top