Databricks

BAZA · 06-28-2023

When importing a .csv file with leading and/or trailing empty spaces around the separators, the output results in strings that appear to be trimmed on the output table or when using .display() but are not actually trimmed.It is possible to identify t...

BAZA · 06-28-2023

If I use a substr to select that character it returns an empty, but not null string. I cannot manually select the value of the cell. By copy and pasting the output into excel, I can select the space and an online decoder indicates that is a \x20 char...

BAZA · 06-28-2023

I created the .csv by hand and wrote the spaces using the space bar. 路‍♀️

BAZA · 06-28-2023

Usually displaying the columns is enough to identify the spaces. I often do that to make sure if I need a trim() on join operations because some tables that I work with have trailing spaces. But in this odd case they are not visible. Even copying the...

Databricks

User Stats

User Activity

Invisible empty spaces when reading .csv files

Re: Invisible empty spaces when reading .csv files

Re: Invisible empty spaces when reading .csv files

Re: Invisible empty spaces when reading .csv files