Tag Archives: substring

Tip – Excel formula to convert Instance Name to Server Name

Below formula will give sub string preceding \ Advertisements

Posted in Script, Uncategorized | Tagged , , , , , | Leave a comment

SQL – Remove special Characters from string

I had a requirement to eliminate all the special characters except alphabets and numbers. The traditional way to handle it REPLACE( REPLACE( ‘#My &String’, ‘!’, ” ), ‘#’, ” ) was not helping as I need to list all possible … Continue reading

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , , , , , , , , , , | Leave a comment