Mis ultimas reseƱas de Peliculas

Saturday, March 20, 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?"

Sunday, March 07, 2010

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,"\",""))))