I import a CSV file on Qgis.
In excel I see an incription like that ¨54235¨ and in the attribute table in qgis as well as in notepad it looks like that ¨ 54 235¨ *not space but tab.
The column when it was an excel file it was created like text join (e.g: =A11&B12)
The initial columns A & B as well have the same problem (e.g. ¨012¨ apears ¨ 012¨ with a tab.
Do you know a solution to that problem?
In your excel spreadsheet copy the column with the values in it, then using "paste special" select "values". If this doesn't work you can remove all unnecessary spaces in your excel sheet before saving as a csv and importing. To do this you can use the find and replace function: open find and replace, put a single space in the "Find what" box and nothing in the "Replace with" box. You can then use "Replace all" to do all of them in one go or go through each in turn if there are other cells in the your document you don't want to remove the spaces from. Alternatively in an adjoining column you can use the "Substitute" function to remove all spaces. The syntax for this would be 'Substitute(A1, " ", ""). This can be copied down the column and then use the copy and paste values for this column to overwrite the original values and delete the column with the equation in. If you only wanted to remove the spaces at the beginning and/or end of the string in your cell then you cold use the "Trim" function. The syntax for this would be 'Trim(A1)'. Hope this is more helpful than my first answer!
In QGIS use Calculating field for table and remove space with trim fonction and replace fonction.
It was not a space but a tab.
They way to fix it is with Replace in Notepad++.
