1

I have thousands of points currently saved as a Drawing Interchange file that I brought into a QGIS project. Each point has attributes that has one bar of text assigned to it. I need to add a word above these points and also flip two of the points for every circumstance. Since there are thousands it would be a real waste of time to do this for each point.

As shown in the picture there are numbers on top and then the names underneath. I want the Top number and the name to switch places. After that I need to add the phrase 'N/f' above both number and the name. I know how to get rid of the other two rows of numbers on the bottom through excel.enter image description here

enter image description here

  • I've tried by bringing it into excel and reattaching it as a table in QGIS but then the text doesnt flip. I cant seem to get it to switch the position of two points. They are consecutive if that helps. Unsure what direction to go. – Shub Jun 26 '17 at 12:21
  • Can you edit your question and add a screen shot of what it currently looks like and another one of what the desired output should look like? This will help provide readers more content. – artwork21 Jun 26 '17 at 12:34
  • @artwork21 done. As stated, I need to flip the top two lines with one another. – Shub Jun 26 '17 at 12:46
  • For one you'll have to convert the dxf to a GIS layer like Esri Shapefile that is editable in QGIS, make edits against shapefile version than convert back to dxf. Are the two lines of text in one point feature or two point features? – artwork21 Jun 26 '17 at 12:52
  • 1
    so when loaded (and/or joined) in QGIS, your attribute table has one column per 'text bar' (like name, date, id, ...)? – ThingumaBob Jun 26 '17 at 12:54
1

I brought the DXF file into AutoCad and went through my approach to swap the order of text lines. I brought a shapefile into QGIS and edited it through Excel to say 'N/F' and 'T.A. #' and brought those both back into QGIS, joined them to the existing shapefile, and then converted the file back into ACAD.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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