How to remove any post that is older than X days in WordPress

To remove any post that is older than X days in WordPress you can use the query below.

Sample mySQL

DELETE FROM wp_posts WHERE post_type = 'post' AND DATEDIFF(NOW(), post_date) > X

How to count the different words of a string in Python

To count the different words of a string in Python you can use the following snippet.

Sample Python

    
input = "Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in languages such as C. The language provides constructs intended to enable clear programs on both a small and large scale.Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive standard library.Like other dynamic languages, Python is often used as a scripting language, but is also used in a wide range of non-scripting contexts. Using third-party tools, such as Py2exe or Pyinstaller, Python code can be packaged into standalone executable programs. Python interpreters are available for many operating systems.CPython, the reference implementation of Python, is free and open source software and has a community-based development model, as do nearly all of its alternative implementations. CPython is managed by the non-profit Python Software Foundation."
words = input.split(' ')

wordcounter = {}
for word in words:
    if word in wordcounter:
        wordcounter[word] += 1
    else:
        wordcounter[word] = 1

sortedWords = sorted([(counter,word) for word,counter in wordcounter.items()],reverse=True)
print "Word counts: " + str(sortedWords)
print "Most popular word: " + str(sortedWords[0][1]) + " used " + str(sortedWords[0][0]) + " times."

How to capitalize a string in Python

To capitalize a string in Python you can use the following snippet.

Sample Python

myPhrase = "HEllo wOrld!";
myPhrase = myPhrase.lower();
capChars = []
for word in myPhrase.split(' '):
  if len(word) > 1:
    capChars.append(word[0].upper() + word[1:])
  else:
      capChars.append(word.upper())
capChars = ' '.join(capChars)
print capChars;

Output:

Hello World!

another much simpler approach posted by Gomokoo on Twitter would be

print "HEllo wOrld!".lower().title();

Output:

Hello World!

How to get the wordcount of a string in C# and VB.NET

To get the wordcount of a string in C# and VB.NET you can use the following snippet.

Sample C#

public static int WordCount(string s)
{
	return Regex.Matches(s, @"[\S]+").Count;
}

Sample VB.NET

Public Shared Function WordCount(s As String) As Integer
	Return Regex.Matches(s, "[\S]+").Count
End Function

How to get a word by index in C# and VB.NET

To get a word by index in C# and VB.NET you can use the following snippet.

Sample C#

public static string GetWordByIndex(string input, int index)
{
	try
	{
		var words = input.Split(' ');
		if ((index < 0) || (index > words.Length - 1))
		{
			throw new IndexOutOfRangeException("Index out of range!");
		}
		return words[index];
	}
	catch (Exception ex)
	{
		//handle the exception your way
		return string.Empty;
	}
}

Sample VB.NET

Public Shared Function GetWordByIndex(input As String, index As Integer) As String
	Try
		Dim words = input.Split(" ")
		If (index < 0) OrElse (index > words.Length - 1) Then
			Throw New IndexOutOfRangeException("Index out of range!")
		End If
		Return words(index)
	Catch ex As Exception
		'handle the exception your way
		Return String.Empty
	End Try
End Function