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.
Cet exercice fait partie du cours
Data Analysis in Google Sheets
Instructions
- In column E, create aFilm IDfor each film by extracting the first four letters in theTitle.
- In column F, create aDirector IDfor each director by extracting the first letter followed by the final three letters inDirector.
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
 Commencer l’exercice
Commencer l’exercice