Skip to content

Instantly share code, notes, and snippets.

@devlatte

devlatte/thousand separator.sql

Created July 29, 2020 04:11
Show Gist options
  • Save devlatte/3bb923ac0b70aa02a5645012aecf2f28 to your computer and use it in GitHub Desktop.
Save devlatte/3bb923ac0b70aa02a5645012aecf2f28 to your computer and use it in GitHub Desktop.
Download ZIP
presto add thousand separator w/ regexp, regular expression
Raw
thousand separator.sql
select regexp_replace('100000', '(\d{1,3})(?=(\d{3})+(?!\d))', '$1,');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment