first-letter-capitalization-ii

java

python3

python

javascript

typescript

csharp

golang

kotlin

swift

rust

ruby

dart

scala

elixir

erlang

racket

cangjie

bash

mysql

mssql

postgresql

oraclesql

pythondata

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>

A word is a maximal non-empty sequence of characters that does not contain a space.

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

<ul>
	<li>If the word starts with a character that is not an English letter, leave the entire word unchanged.</li>
	<li>Otherwise, if the word consists of two or more non-empty parts of English letters connected by hyphens <code>-</code>, convert the first letter of each part to uppercase and the remaining letters of each part to lowercase. For example, <code>top-rated</code> becomes <code>Top-Rated</code> and <code>FR-ONT-end</code> becomes <code>Fr-Ont-End</code>.</li>
	<li>Otherwise, convert the first letter of the word to uppercase and all remaining English letters to lowercase. Any special characters remain unchanged.</li>
</ul>

All other formatting and spacing must remain unchanged.

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>The hyphenated word &quot;QUICK-brown&quot; becomes &quot;Quick-Brown&quot;.</li>
		<li>Other words follow the normal capitalization rules.</li>
	</ul>
	</li>
	<li>For content_id = 3:
	<ul>
		<li>The 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>&quot;web-based&quot; becomes &quot;Web-Based&quot;.</li>
		<li>&quot;FRONT-end&quot; becomes &quot;Front-End&quot;.</li>
	</ul>
	</li>
</ul>
</div>

&nbsp;
Constraints:

<ul>
	<li><code>content_text</code> contains only English letters, spaces, and the characters <code>\</code>, <code>@</code>, <code>-</code>, <code>/</code>, <code>^</code>, and <code>,</code>.</li>
</ul>

capitalize_content

First Letter Capitalization II

数据库

表：<code>user_content</code>

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

单词是指不包含空格的极大非空字符序列。

编写一个解决方案，按照以下规则对 <code>content_text</code> 列中的文本进行转换，并对每个单词应用这些规则：

<ul>
	<li>如果单词以一个不是英文字母的字符开头，则保持整个单词不变。</li>
	<li>否则，如果单词由两个或更多非空的英文字母部分通过连字符 <code>-</code> 连接而成，则将每个部分的首字母转换为大写，并将每个部分的其余字母转换为小写。例如，<code>top-rated</code> 转换为 <code>Top-Rated</code>，<code>FR-ONT-end</code> 转换为 <code>Fr-Ont-End</code>。</li>
	<li>否则，将单词的首字母转换为大写，并将其余所有英文字母转换为小写。所有特殊字符保持不变。</li>
</ul>

所有其他格式和空格必须保持不变。

返回结果表，其中同时包含原始的 <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>

&nbsp;

提示：

<ul>
	<li><code>content_text</code> 仅包含英文字母、空格以及字符 <code>\</code>、<code>@</code>、<code>-</code>、<code>/</code>、<code>^</code> 和 <code>,</code>。</li>
</ul>