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
Anleitung zur Übung
- In column
E
, create aFilm ID
for each film by extracting the first four letters in theTitle
. - In column
F
, create aDirector ID
for each director by extracting the first letter followed by the final three letters inDirector
.
Interaktive Übung zum Anfassen
Setzen Sie die Theorie mit einer unserer interaktiven Übungen in die Tat um
