Replacing string data
Sometimes you will need to make sure that the data you are extracting does not contain any whitespace. There are many different approaches you can take to cleanse and prepare your data for these situations. A common technique is to replace any whitespace with an underscore.
In this example, we are going to practice finding and replacing whitespace characters in the title column of the film table using the REPLACE() function.
Bu egzersiz
Functions for Manipulating Data in PostgreSQL
kursunun bir parçasıdırEgzersiz talimatları
- Replace all whitespace with an underscore.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
-- Replace whitespace in the film title with an underscore
___(___, ___, ___) AS title
FROM film;