var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to replace instances of "#"
I do a lot of address correction and updating. The post office prefers either "Ste" or "Rm" as opposed to just using the pound sign #.
However if I try to filter and replace "#" with or without the quotation marks it simply selects and replaces every single number value (text value for the field).
Is there a way to actually replace the pound sign since it's assuming it as a symbol and not being literal? I'm assuming this would have to be done in a query....
Have you tried casting the value to text, then make your changes and write it back to the table?
If by casting you mean changing the field to text value? It's already in text =/ That's why I'm having the problem. If I misunderstood, then I'm sorry.
You could use the Chr Function to refer to the ASCII value of the pound sign.