CommencerCommencer gratuitement

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

Cet exercice fait partie du cours

Data Analysis in Google Sheets

Afficher le cours

Instructions

  • 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.

Exercice interactif pratique

Passez de la théorie à la pratique avec l’un de nos exercices interactifs

Commencer l’exercice