' issue

Hi all,

I am going to come out strong with this pretty hairy problem (well I think it is).

I have a vbs page that calls objects from a database via XML. The XML stores apostrphe's (') as ' as it is supposed to but as HTML 4 won't recognise the entity, the objects come out with ' in the middle of them.

I have done research trying to find a solution for this problem and indeed there seem to be many solutions around using XML/XSL and php. However I am not able to change the XML/XSL file so it has to be done in the vbs - the problem being (and I may have this wrong) that you can't search for a substring of a string without iterating through each character.

I know I basically just need a function that takes the object searches for ' in the string, replaces it with &#39 and returns the object but I am unsure of how to search the string for the entity - and even if this will work in asp, it would be the first time I have gotten WAY off track. I am not really familar with the whole system this problem is affecting or with XML so any enlightenment you guys could give me would be greatly appreciated.

Thanks

Ah ok - Never mind all I have solved it.