0

I am trying to filter out around 1000 rows and delete them in MapInfo as they are no longer required in the data set. If there was a smaller quantity then I would use an SQL Query but it has its limits and I can't get it to work.

The numbers/rows I need to filter out are currently in a Notepad in the following format 46061871, 46062951, 46063180, etc. and none of the other fields in the rows would allow me to delete them so it has to be done via the unique values.

Can anyone advise a workaround or solution?

2 Answers 2

2

These eight-digit values are in a column in MapInfo, correct? If you also have them in one column in NotePad, you can join the two tables where the NotePad values have matches in the MapInfo table; then delete the resulting join/selection from MapInfo.

1
  • Yes! I didn't think of this - it should work perfectly! Thanks Ross!
    – Aydo16
    Commented Jul 18, 2019 at 14:17
0
  • in query selection (query in 32bit) in spatial tab (sql select for 64bit version). use following function alternatives: OR if you consider graphical selection for: line, polyline, and polygon (this will select corresponding vector object). example: by using sql select menu in the sql menu pane. chose your table then type or by chosing the function option: Str$(obj)="polyline"

  • if you prefer the attribute selection with specific 'field' (column).. use ANY statement. for example Remark=ANY("VN1","VN2") -> this will select only your data in 'remark' field that contains'vn1' and 'vn2'. if you change = with <> this will querying the opposite.

source: https://customer.precisely.com/s/article/MapInfo-Professional-and-how-ANY-ALL-and-IN-used-in-a-select-or-query-statements?language=en_US

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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