I've been trying to convert a decimal row into a string row using a few methods. Below is my CSV file:


also, note that csv header has been updated too,


And white space was removed from the headers removed. (including the blank cells)

First method using to string:

To string

The second method using quotes:

enter image description here

Tried the same with integers, a similar result was depicted:

Integer to string

enter image description here

Removing the file name from the column doesn't help:

enter image description here

Using QGIS 3.6.3-Noosa. What I'm doing wrong?

  • 1
    @MBain File name is blacked out – BPDESILVA Jun 14 '19 at 2:54
  • 2
    Try to use items in 'Fields and Values' menu on the right hand of the text editor. There are listed all fields in the current layer. Maybe your field names are somehow mangled... – DavidP Jun 14 '19 at 5:37
  • Did you try: to_string("AverageRainfall") ? You need the expression to_string("ColumnName") with the column name between quotation marks. – Philip Whitten Jun 20 '19 at 2:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.