Erste SchritteKostenlos loslegen

Extracting characters

Now that you understand the concept of character indexes in strings, you can begin to use them to extract characters.

In this exercise, you've been tasked with creating a Film ID and Director ID for each film and director.

The Film ID should consist of the first four letters in Title, so Doctor Strange would have the Film ID, Doct.

The Director ID should consist of the first letter followed by the final three letters, so Quentin Tarantino would have the Director ID, Qino.

Diese Übung ist Teil des Kurses

Datenanalyse in Google Sheets

Kurs anzeigen

Anleitung zur Übung

  • In column E, create a Film ID for each film by extracting the first four letters in the Title.
  • In column F, create a Director ID for each director by extracting the first letter followed by the final three letters in Director.

Interaktive Übung zum Anfassen

Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um

Beginnen Sie mit dem Training