How can I limit the number of characters to select in a PostgreSQL substring?

Question

I am trying to pull off the first part of an email before the @ symbol.

This works:

SELECT substring(email, '(\S+)(@{1})')

However I'd like to also only pull off the first 15 (or less) characters.

How can I do this?

SELECT substring(email, '(\S+)(@{1})', 15)

doesn't work.

Thanks!

Gordon Linoff · Accepted Answer · 2018-08-24 14:31:45Z

4

How about:

select left(substring(email, '^[^@]*'), 15)

Or, if you want one regular expression:

select substring(email, '^[^@]{1,15}')

answered Aug 24, 2018 at 14:31

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1