Separate camel case String


Below is the query to separate camel case string and removing first lower part from the string on condition IF @skipFirstLowerPart = 0 means skip first lower part from the string and                 IF @skipFirstLowerPart = 1 then do not skip first lower part from the string

DECLARE @str VARCHAR(100) = 'txtFirstName'
DECLARE @skipFirstLowerPart INT = 0 -- 0 yes 1 no

DECLARE @len INT = LEN(@str), @ptr INT = 1, @chk INT = 0
DECLARE @newstr VARCHAR(100) = ''

WHILE @len > 0
BEGIN
      DECLARE @char CHAR(1) = SUBSTRING(@str, @ptr, @ptr+1)
     
      IF @skipFirstLowerPart = 0
      BEGIN
            IF (CONVERT(VARBINARY(128), @char) = CONVERT(VARBINARY(128), LOWER(@char))) AND (@chk = 0)
            BEGIN
                  SET @char = ''
            END
      END
      IF CONVERT(VARBINARY(128), @char) <> CONVERT(VARBINARY(128), LOWER(@char))
      BEGIN
            SELECT @newstr += ' ', @chk = 1
      END
     
      SET @newstr += @char
     
      SELECT @ptr += 1, @len -= 1
END

SELECT LTRIM(RTRIM(@newstr))

RESULT :
First Name

Comments

Post a Comment

Popular posts from this blog

Change Css Class of li in ul onclick

Image
Below is the simple and a short code to change or set the background color of item in menu onclick or active tab of menu (i.e. li of ul) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>List Item</title> <style type="text/css"> ul {     list-style-type:none;     float:left;     border-bottom: solid 2px Red;     padding-right:40px; } ul li {     float:left;     width:auto;     padding:8px;     display:block;     cursor:pointer; } </style> <script type="text/javascript" language="javascript">     function checklist(ctrl)     {   ...
Read more

Find missing sequence number. Get the numbers where sequence is missing.

Most of the time the question was asked while having Database interview that we have number sequence present in a table but some numbers are missing. Can you write the query to detect where number is missing from sequence and if possible then also can get the missing number? OK, it’s not a rocket science so let’s begin. Please give me a paper and a pen to write query Sir. I am using a Temporary variable table here. DECLARE @Temp TABLE (        Id INT IDENTITY ( 1 , 1 ),        Num INT ) INSERT INTO @Temp ( Num ) VALUES ( 1 ) ,( 2 ), ( 4 ), ( 6 ), ( 7 ), ( 9 ) SELECT * FROM @Temp SELECT a . Id , a . Num , b . Num , ( a . Num - b . Num ) as Diff , ( b . Num + 1 ) as MissingNum FROM @Temp a LEFT JOIN @Temp b ON b . Id = ( a . Id - 1 ) WHERE ( a . Num - b . Num ) > 1 You see it’s just a simple SELECT statement but tricky. OK, yes it will produce m...
Read more

Change Text Color with Javascript at more that one part in single page.

Below code is the modified version of the topic name  Change Text Color with Javascript as one of the reader demands. Copy and paste the code in notepad and save it as any name with .html extension and run in browser. Logic behind to use the same feature in different parts of the page is by using class instead of id. Id is unique and cannot be used more than once but class can be used more than once to group the feature. The previous code uses ID and this one use Class on div. < html > < head >     < title > Text Color Change </ title >     < script type ="text/javascript" language ="javascript">         elmColor = 0;         function changeColor(elmColor) {             for (i = 0; i < document.getElementsByClassName( 'colorChange' ).length; i++) { ...
Read more