Aan de slagGa gratis aan de slag

Substituting characters

In this exercise, you'll be using your text manipulation skills to create standardized URLs for each film in the table.

These URLs must have three parts: www., the Film URL Slug, and -film.com.

For example, the URL forDoctor Strange would be:

www.doctor-strange-film.com

Deze oefening maakt deel uit van de cursus

Data Analysis in Google Sheets

Cursus bekijken

Oefeninstructies

  • In A14:A23, remove any colons from the film titles by replacing them with an empty string.
  • In C14:C23, create the Film URL Slug by replacing the spaces in A14:A23 with dashes (-), and making all text lowercase.
  • In E14:E23, create the Film Website by adding www. to the beginning of Film URL Slug and -film.com to the end.

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen