first-letter-capitalization-ii

java

python

python3

mysql

mssql

oraclesql

csharp

javascript

typescript

bash

swift

kotlin

dart

golang

ruby

scala

rust

racket

erlang

elixir

pythondata

postgresql

cangjie

Database

Table: <code>user_content</code>

<pre>
+-------------+---------+
| 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.
</pre>

Write a solution to transform the text in the <code>content_text</code> column by applying the following rules:

<ul>
	<li>Convert the first letter of each word to uppercase and the remaining letters to lowercase</li>
	<li>Special handling for words containing special characters:
	<ul>
		<li>For words connected with a hyphen <code>-</code>, both parts should be capitalized (e.g., top-rated&nbsp;&rarr; Top-Rated)</li>
	</ul>
	</li>
	<li>All other formatting and spacing should remain unchanged</li>
</ul>

Return the result table that includes both the original <code>content_text</code> and the modified text following the above rules.

The result format is in the following example.

&nbsp;
Example:

<div class="example-block">
Input:

user_content table:

<pre class="example-io">
+------------+---------------------------------+
| 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 |
+------------+---------------------------------+
</pre>

Output:

<pre class="example-io">
+------------+---------------------------------+---------------------------------+
| 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 |
+------------+---------------------------------+---------------------------------+
</pre>

Explanation:

<ul>
	<li>For content_id = 1:
	<ul>
		<li>Each word&#39;s first letter is capitalized: &quot;Hello World Of Sql&quot;</li>
	</ul>
	</li>
	<li>For content_id = 2:
	<ul>
		<li>Contains the hyphenated word &quot;QUICK-brown&quot; which becomes &quot;Quick-Brown&quot;</li>
		<li>Other words follow normal capitalization rules</li>
	</ul>
	</li>
	<li>For content_id = 3:
	<ul>
		<li>Hyphenated word &quot;modern-day&quot; becomes &quot;Modern-Day&quot;</li>
		<li>&quot;DATA&quot; is converted to &quot;Data&quot;</li>
	</ul>
	</li>
	<li>For content_id = 4:
	<ul>
		<li>Contains two hyphenated words: &quot;web-based&quot; &rarr; &quot;Web-Based&quot;</li>
		<li>And &quot;FRONT-end&quot; &rarr; &quot;Front-End&quot;</li>
	</ul>
	</li>
</ul>
</div>

capitalize_content

First Letter Capitalization II

表：<code>user_content</code>

<pre>
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| content_id | int |
| content_text| varchar |
+-------------+---------+
content_id 是这张表的唯一主键。
每一行包含一个不同的 ID 以及对应的文本内容。
</pre>

编写一个解决方案来根据下面的规则来转换&nbsp;<code>content_text</code>&nbsp;列中的文本：

<ul>
	<li>将每个单词的 第一个字母&nbsp;转换为 大写，其余字母 保持小写。</li>
	<li>特殊处理包含特殊字符的单词：
	<ul>
		<li>对于用短横&nbsp;<code>-</code>&nbsp;连接的词语，两个部份&nbsp;都应该&nbsp;大写（例如，top-rated&nbsp;→ Top-Rated）</li>
	</ul>
	</li>
	<li>所有其他 格式 和 空格 应保持 不变</li>
</ul>

返回结果表同时包含原始的&nbsp;<code>content_text</code> 以及根据上述规则修改后的文本。

结果格式如下例所示。

&nbsp;

示例：

<div class="example-block">
输入：

user_content 表：

<pre class="example-io">
+------------+---------------------------------+
| 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 |
+------------+---------------------------------+
</pre>

输出：

<pre class="example-io">
+------------+---------------------------------+---------------------------------+
| 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 |
+------------+---------------------------------+---------------------------------+
</pre>

解释：

<ul>
	<li>对于 content_id = 1：
	<ul>
		<li>每个单词的首字母都是大写的："Hello World Of Sql"</li>
	</ul>
	</li>
	<li>对于 content_id = 2：
	<ul>
		<li>包含的连字符词 "QUICK-brown" 变为 "Quick-Brown"</li>
		<li>其它单词遵循普通的首字母大写规则</li>
	</ul>
	</li>
	<li>对于 content_id = 3：
	<ul>
		<li>连字符词 "modern-day" 变为 "Modern-Day"</li>
		<li>"DATA" 转换为 "Data"</li>
	</ul>
	</li>
	<li>对于 content_id = 4：
	<ul>
		<li>包含两个连字符词："web-based" → "Web-Based"</li>
		<li>以及 "FRONT-end" → "Front-End"</li>
	</ul>
	</li>
</ul>
</div>