ÎncepețiÎncepe gratuit

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

Acest exercițiu face parte din cursul

Analiza datelor în Google Sheets

Vezi cursul

Instrucțiuni pentru exercițiu

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

Exercițiu interactiv practic

Transformă teoria în practică cu unul dintre exercițiile noastre interactive

Începe exercițiul