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
.
Este ejercicio forma parte del curso
Análisis de datos en Google Sheets
Instrucciones de ejercicio
- 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
.
Ejercicio interactivo práctico
Convierte la teoría en acción con uno de nuestros ejercicios interactivos
