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

More By Author:

Check out these other kata created by PG1

Stats:

CreatedJun 14, 2017
PublishedJun 14, 2017
Warriors Trained7439
Total Skips1453
Total Code Submissions13191
Total Times Completed2464
SQL Completions2464
Total Stars77
% of votes with a positive feedback rating87% of 365
Total "Very Satisfied" Votes289
Total "Somewhat Satisfied" Votes60
Total "Not Satisfied" Votes16
Total Rank Assessments12
Average Assessed Rank
7 kyu
Highest Assessed Rank
6 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • PG1 Avatar
  • jhoffner Avatar
  • smile67 Avatar
Ad