Is there a way to convert multiple columns at once from string to text, or to other data formats?

Question

I have multiple data fields that need to be converted from string to text files. When I save them as "text" in excel or open office, they still load up as string files in QGIS. How can I convert more than one column at once from string to text (or even integer, etc. if the situation arises)?

Thanks for your help! Alex

See if this post from Anita Graser is what you need. http://anitagraser.com/2011/03/07/how-to-specify-data-types-of-csv-columns-for-use-in-qgis/ — Alexandre Neto, Aug 13 '13 at 10:33

score 1 · Answer 1 · answered Jun 13 '13 at 18:32

A string is just a sequence of characters as is text, for what you're doing they're bassically the same thing.

From dictionary.com

String 16. Computers, Linguistics . a linear sequence of symbols, words, characters, or bits that is treated as a unit.

score 0 · Answer 2 · answered Dec 23 '22 at 20:15

0

I would recommend using the MMQGIS plug in. Under this plug in select "modify" -> "text to float" of "float to text" and select the columns you wish to change. The output will be a new shapefile where the columns types will be changed

answered Dec 23 '22 at 20:15

Ian Moffit

357
1
11

Is there a way to convert multiple columns at once from string to text, or to other data formats?

2 Answers2