I have imported a .kml file into QGIS, and the data is all shoved together into a single field like this: Fine, it's pipe delimited - easy to change the delimiter like in LibreOffice calc imports I thought. But could not find a solution within QGIS.
Next attempt: change the delimiter in the kml file to the common default comma delimited using Sed:
sed -e 's/|/,/g' in.kml > out.kml
Still no joy - it looks exactly the same as above, only with commas instead of pipes. So someone please help me, and I'm sure it will be of use to others.
(P.s. a colleague and I have tried the same thing in ArcGIS and the same problem is encountered).