james_halliwell
Registered User.
- Local time
- Today, 17:36
- Joined
- Feb 13, 2009
- Messages
- 211
Hi all,
We have a spreadsheet that i upload onto a table, i use on of the fields to build a file path but if there is a special character it causes problems,
i need to replace the below with spaces if they are in my field called path
• < (less than)
• > (greater than)
• : (colon)
• " (double quote)
• / (forward slash)
• \ (backslash)
• | (vertical bar or pipe)
• ? (question mark)
• * (asterisk)
• . (full stop)
• , (commer)
please can someone advise on how i can do this in some sort of update query please
We have a spreadsheet that i upload onto a table, i use on of the fields to build a file path but if there is a special character it causes problems,
i need to replace the below with spaces if they are in my field called path
• < (less than)
• > (greater than)
• : (colon)
• " (double quote)
• / (forward slash)
• \ (backslash)
• | (vertical bar or pipe)
• ? (question mark)
• * (asterisk)
• . (full stop)
• , (commer)
please can someone advise on how i can do this in some sort of update query please