QGIS Labeling – How to Label with Only the First Letter of String in QGIS

labelingqgisstring

I have a field called "Genus" where there are string values, for example, the word 'Pinus'.

I want my label to show only the first letter of this word so in my example 'P'.

I was trying to use Function Editor. I was contriving with field.row[0], but I'm not sure with the rest of the syntax.

Maybe there is another solution for it?

Best Answer

Use this in your label composer, it should do the trick :

left("Genus", 1)

Here's a list of functions you can use in your expressions

Related Solutions

[GIS] Using replace string function in QGIS Field Calculator

replace( '(B)','(B)','County')

tells QGIS to replace the '(B)' in '(B)' with 'Country'.

You want

replace("Name",'(B)','Country')

= replace the '(B)' in "Name" with 'Country'.

Note that the double quotes indicate a field name while the single quotes refer to a static string. These are not interchangeable.

[GIS] Extracting only number from address in QGIS Attribute Table

If the addresses are all formatted similarly as in your example, you may try this expression:

left("1250 Main Street", strpos("1250 Main Street", '\\s') - 1)

Firstly, the expression strpos finds the position of the first white space in the string (i.e. 5, the result is "1250 "); then it saves the left part of the string from the position 4: the result is 1250.

You may obviously change "1250 Main Street" with the name of the field of interest.

Best Answer

Related Solutions

[GIS] Using replace string function in QGIS Field Calculator

[GIS] Extracting only number from address in QGIS Attribute Table

Related Question