g3301_3400.s3374_first_letter_capitalization_ii.readme.md Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of leetcode-in-java21 Show documentation

Java-based LeetCode algorithm problem solutions, regularly updated

There is a newer version: 1.38

3374\. First Letter Capitalization II

Hard

SQL Schema

Table: `user_content`

    +-------------+---------+
    | Column Name | Type    |
    +-------------+---------+
    | content_id  | int     |
    | content_text| varchar |
    +-------------+---------+
content_id is the unique key for this table. Each row contains a unique ID and the corresponding text content. 

Write a solution to transform the text in the `content_text` column by applying the following rules:

*   Convert the **first letter** of each word to **uppercase** and the **remaining** letters to **lowercase**
*   Special handling for words containing special characters:
    *   For words connected with a hyphen `-`, **both parts** should be **capitalized** (**e.g.**, top-rated → Top-Rated)
*   All other **formatting** and **spacing** should remain **unchanged**

Return _the result table that includes both the original `content_text` and the modified text following the above rules_.

The result format is in the following example.

**Example:**

**Input:**

user\_content table:

    +------------+---------------------------------+
    | content_id | content_text                    |
    +------------+---------------------------------+
    | 1          | hello world of SQL              |
    | 2          | the QUICK-brown fox             |
    | 3          | modern-day DATA science         |
    | 4          | web-based FRONT-end development |
    +------------+---------------------------------+ 

**Output:**

    +------------+---------------------------------+---------------------------------+
    | content_id | original_text                   | converted_text                  |
    +------------+---------------------------------+---------------------------------+
    | 1          | hello world of SQL              | Hello World Of Sql              |
    | 2          | the QUICK-brown fox             | The Quick-Brown Fox             |
    | 3          | modern-day DATA science         | Modern-Day Data Science         |
    | 4          | web-based FRONT-end development | Web-Based Front-End Development |
    +------------+---------------------------------+---------------------------------+ 

**Explanation:**

*   For content\_id = 1:
    *   Each word's first letter is capitalized: "Hello World Of Sql"
*   For content\_id = 2:
    *   Contains the hyphenated word "QUICK-brown" which becomes "Quick-Brown"
    *   Other words follow normal capitalization rules
*   For content\_id = 3:
    *   Hyphenated word "modern-day" becomes "Modern-Day"
    *   "DATA" is converted to "Data"
*   For content\_id = 4:
    *   Contains two hyphenated words: "web-based" → "Web-Based"
    *   And "FRONT-end" → "Front-End"