Skip to content

Instantly share code, notes, and snippets.

@wviana

wviana/REGEX.sql

Created February 3, 2017 12:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wviana/8d66bfbe317e3dbc748234f787504b82 to your computer and use it in GitHub Desktop.
Save wviana/8d66bfbe317e3dbc748234f787504b82 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
REGEX.sql
'^(?:(?!.*(A ?4))).*[^T\d]((\d+) ?[xX] ?\d+[[:alpha:]]*\y).*$'::text AS nXm,
'^.*\y(CX[ c/]*(\d+)[^\d]*)\y.*$'::text AS CXn,
'^.*\y(CX(\d+)UN)\y.*$'::text AS CXnUN,
'^.*[^\d]((\d+) ?ROLOS).*$'::text AS nRolos,
'^.*(C/ ?(\d+) *UN).*$'::text AS CBarrAnUN,
'^.*[^\d]((\d+) ?UN).*$'::text AS nUN,
'^.*[^\d]((\d+)\/).*$'::text AS nBarra
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment