7 kyu
SQL: Regex String to Table
2,464PG1
Description:
You are given a table random\_string
that has the following format:
random_string schema
- text
The text field holds a single row which contains a random string.
Your task is to take the random string and split it on each vowel (a, e, i, o, u) then the resultant substrings will be contained in the output table, formatted as:
output table schema
- results
Note that the vowels should be removed.
If there are no vowels, there will only be one row returned. Where there are multiple vowels in succession, you will see empty rows. A row should be created on each break, whether there is content in the row or not.
Regex is advised but not mandatory.
Fundamentals
Regular Expressions
SQL
Similar Kata:
Stats:
Created | Jun 14, 2017 |
Published | Jun 14, 2017 |
Warriors Trained | 7439 |
Total Skips | 1453 |
Total Code Submissions | 13191 |
Total Times Completed | 2464 |
SQL Completions | 2464 |
Total Stars | 77 |
% of votes with a positive feedback rating | 87% of 365 |
Total "Very Satisfied" Votes | 289 |
Total "Somewhat Satisfied" Votes | 60 |
Total "Not Satisfied" Votes | 16 |
Total Rank Assessments | 12 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 6 kyu |
Lowest Assessed Rank | 8 kyu |