I am not much of a programmer but I have a requirement to export an Access 2013 table query to XML and i need to be able to replace all the invalid XML characters before I can export it. How can I do a table wide find and replace for these.
For instance:
& needs to be replaced with &
< needs to be replaces with <
> needs to be replaced with >
' needs to be replaced with &pos;
" needs to be replaced with "
Thank you ahead of time, any suggestions on the best way to do there, I have to search the entire table and replace all these wherever it sees them and i have not found a way to do it
For instance:
& needs to be replaced with &
< needs to be replaces with <
> needs to be replaced with >
' needs to be replaced with &pos;
" needs to be replaced with "
Thank you ahead of time, any suggestions on the best way to do there, I have to search the entire table and replace all these wherever it sees them and i have not found a way to do it
