Randal Hale (He/Him)Is concat_ws missing in QGIS 3.44? I have concat - but that's not doing what I need it to do.#qgis
Barry Rowlingson@rjhale1971 I cant find any evidence of it ever being in QGIS, apart from one dubious-looking blog that is probably LLM slop which has wasted ten minutes of my life searching the QGIS docs of old versions. Its an SQL function but not a QGIS expression...
@geospacedman Maybe that's where I was remembering it from - sql. I ran across the same blog article which made me think it had to be there. I fixed it in Postgresql and I'll do some digging way later.
cartocalypseOH LOOK, it's @MapScaping polluting the web with shit.
@geospacedman @rjhale1971 @MapScaping
And now he finally deleted that page, lol.
Archived: https://web.archive.org/web/20250517054940/https://mapscaping.com/concatenate-fields-in-qgis/
Concatenate Fields In QGIS - May 17, 2025
Field concatenation is a fundamental data manipulation technique that combines data from multiple fields into one, enhancing data readability and utility. This can be crucial for tasks like labeling, creating comprehensive address lists, or preparing data for analysis and reporting.
@cartocalypse @rjhale1971 @MapScaping and the hilarious thing is that Nyall D just wrote a patch to implement concat_ws! That blog post was predicting the future!!!
@geospacedman @rjhale1971
Sounds like an evil master plan: Write slop "tutorials", watch users taking it for granted, annoy developer enough to get it implemented :D
Sounds like an evil master plan: Write slop "tutorials", watch users taking it for granted, annoy developer enough to get it implemented :D
Paul Ramsey 🗳️@rjhale1971 Concat_ws is a database superpower, particularly the null handling.
@pwramsey Yep - that's what I needed. I had nulls in addresses but had to add like 8 strings together. I think I'm having some sort of mandela effect. I've sworn I've used it in the field calculator in QGIS because I remember going "Hey this is a SQL command". Probably happened when I married my supermodel wife.
Keith Jenkins@rjhale1971 @pwramsey concat_ws is available in QGIS virtual layer queries, although it doesn't appear as an autocomplete suggestion. It looks like SQLite added it in Nov 2023, which I guess is what enabled it in QGIS virtual layer queries.