Skip to content

Instantly share code, notes, and snippets.

@met

met/gtfs_id_with_underscore.sql

Created October 7, 2024 21:25
Show Gist options
  • Save met/5c245ad729a09f9fe82cd5299444601d to your computer and use it in GitHub Desktop.
Save met/5c245ad729a09f9fe82cd5299444601d to your computer and use it in GitHub Desktop.
Download ZIP
Find stop gtfs id containing underscore with duckdb SQL
Raw
gtfs_id_with_underscore.sql
SELECT * FROM read_csv_auto('stops.txt') WHERE stop_id LIKE '%\_%' ESCAPE '\';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment