Posts

Showing posts from March, 2010

OpenSubtitles.org // View topic - Oscar not downloading subtitles

For all users of the fabulous program OSCAR for downloading subtitles from opensubtitles.org there is a new API ddress located at: http://api.opensubtitles.org/xml-rpc You have to go in preferences and updte the address overwriting it with the new one OpenSubtitles.org // View topic - Oscar not downloading subtitles : "Go in preferences and make sure URL in OSDb is pointing to: http://api.opensubtitles.org/xml-rpc Looks like the API has changed address. Maybe someone should put a sticky post here?"

This formula is used to Find the last occurrence of a Character in a String in Excel

This formula is used to Find the last occurrence of a Character in a String in Excel the reason for this is thst when working with long filenames the last instance of "\"is where the filename starts the formula is : =SEARCH("+-+",SUBSTITUTE(D3,"\","+-+",LEN(D3)-LEN(SUBSTITUTE(D3,"\",""))))