[Qgis-user] Selecting Records Using an external Text File

[Ujaval Gandhi]

You could just add the small text file as a vector layer. Since it is just
1 column, you'll get a table layer with 1 column in the attribute table.
You can then do a table join and check the option to discard non-matching
records.
[image: Logo] <https://spatialthoughts.com/>
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: ujaval at spatialthoughts.com
[image: LinkedIn icon] <https://www.linkedin.com/in/spatialthoughts/>  [image:
Twitter icon] <https://twitter.com/spatialthoughts>



On Sat, Jan 2, 2021 at 3:40 PM Grant Boxer <boxerg at iinet.net.au> wrote:

> I have a located file with 20k+ records containing photo file names,
> locations and other data. I have another list of 500+ containing photo
> file names only (one field/column) that I would like to use to extract
> the data from the 20+k file (e.g. location and other info) by using the
> photo file name. Is there an expression to compare a value in a field in
> the small text file and select that record in the larger file, i.e.
> select by using the small text file? Any suggestions? Hope this makes
> sense.
>
> Cheers Grant Boxer
>
> Perth Western Australia
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210102/cf13c6dd/attachment-0001.html>