Word-Start Case Normalization with Space Preservation

EASY15 pts

A publishing workflow stores user-submitted text snippets with inconsistent capitalization.

Table:

UserContent(content_id, content_text)

Task: For each row, transform content_text using these rules:

Uppercase the first letter of each word.
Lowercase all other letters in that word.
Preserve spaces exactly as-is, including repeated, leading, and trailing spaces.

A word is any maximal sequence of non-space characters. Text rows contain only English letters and spaces.

Return columns in this exact order:

content_id
original_text
converted_text

Final ordering:

content_id ascending

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

UserContent:
| content_id | content_text                      |
|------------|-----------------------------------|
| 1          | hello world of SQL                |
| 2          | the QUICK brown fox               |
| 3          | TOP rated programming BOOKS       |

Output

[
  {"content_id":1,"original_text":"hello world of SQL","converted_text":"Hello World Of Sql"},
  {"content_id":2,"original_text":"the QUICK brown fox","converted_text":"The Quick Brown Fox"},
  {"content_id":3,"original_text":"TOP rated programming BOOKS","converted_text":"Top Rated Programming Books"}
]

Explanation

Each word is normalized to title-style casing while word boundaries remain based on spaces.

Example

Input

UserContent:
| content_id | content_text                     |
|------------|----------------------------------|
| 10         |   leadIng   SPACES and Trailing   |
| 11         | single                           |
| 12         | MIXED   case   TEXT              |

Output

[
  {"content_id":10,"original_text":"  leadIng   SPACES and Trailing   ","converted_text":"  Leading   Spaces And Trailing   "},
  {"content_id":11,"original_text":"single","converted_text":"Single"},
  {"content_id":12,"original_text":"MIXED   case   TEXT","converted_text":"Mixed   Case   Text"}
]

Explanation

All spaces are preserved exactly, including leading, trailing, and repeated separators.

Example

Input

UserContent:
| content_id | content_text    |
|------------|-----------------|
| 21         |                 |
| 22         | a b c           |
| 23         |    x   y        |

Output

[
  {"content_id":21,"original_text":"","converted_text":""},
  {"content_id":22,"original_text":"a b c","converted_text":"A B C"},
  {"content_id":23,"original_text":"   x   y   ","converted_text":"   X   Y   "}
]

Explanation

Empty strings stay empty, and single-letter words are capitalized correctly.

Accepted0/0·0% Acceptance

Constraints

1 <= number of rows in UserContent <= 4000
content_id is unique
1 <= content_id <= 1000000000
0 <= length(content_text) <= 180
content_text contains only English letters and spaces
Words are separated by one or more spaces
Preserve all spaces exactly in the output
Return output columns exactly as specified
Final output must be sorted by content_id ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with required columns

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

UserContent =

[{"content_id":1,"content_text":"hello world of SQL"},{"content_id":2,"content_text":"the QUICK brown fox"},{"content_id":3,"content_text":"TOP rated programming BOOKS"}]

Word-Start Case Normalization with Space Preservation

Hints

Word-Start Case Normalization with Space Preservation

Hints