C# String Manipulation: From "TABLE_NAME" to "TableName"

Question

The best way to do this?

Tried things like that:

public String FormatColumnName(String columnName)
{
    String formatedColumnName = columnName.Replace('_', ' ').Trim();
    StringBuilder result = new StringBuilder(formatedColumnName);
    result[0] = char.ToUpper(result[0]);
    return result.ToString();
}

Didn't work for me, maybe someone could give me a clean Solution on how I can do that.

Answer 1

How about:

string result = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(
       columnName.Replace('_', ' ').Trim().ToLower()).Replace(" ","");

ToTitleCase changes "lower case words" to "Lower Case Words" (but doesn't touch upper case), hence the need to ToLower - then we remove the spaces with Replace.

Answer 2

String.Concat(columnName.Split('_').Select(s => s[0] + s.Substring(1).ToLower()))