Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am working with data in Colombia where decimal points are written as commas. I would love to create a new column in QGIS that would convert all decimal points (periods) to commas for the purpose of labeling. Any thoughts?

share|improve this question

1 Answer 1

You'll want to create a new text column and replace points with commas. The function is replace(original_string, find_text, replace_text); you'll need to convert the original number to a string, too. If you have a column LBL which is the number you want to use as a label:

  1. Start editing the layer, open the attributes table and start the field calculator.
  2. Select an output field name and make sure it's text.
  3. In the 'Field calculator expression', paste the expression replace(to string(LBL), '.', ',' ) and click OK.

For a longer term solution, you could probably change the region on your system too.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.