Get string after '/' character in SQL Postgres

Question

How do I get all numbers after slash in my column? Example: 884/9 and 884/12 I need to get it as "9" and "12".

This one doesn't work - I am using Postgres and Dibi library

substring(source_path, '/(.*)$')

why doens't it work? Please provide sample results. Also what postgres version do you use? — perzsa
– perzsa, Commented May 26, 2016 at 13:10

sagi · Accepted Answer · 2016-05-26 13:11:46Z

3

If you have only one / on your data, and it is always formatted similar to the example you gave, then you can use SPLIT_PART() :

SELECT split_part(source_path, '/', 2) FROM YourTable;

Although I think your query should work. What exactly 'doesn't work' means ?

answered May 26, 2016 at 13:11

sagi

40.6k7 gold badges66 silver badges87 bronze badges

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

2 Comments

Jax-p Over a year ago

Doesn't work means = Unknown syntax at regular '/(.*)$'. As I know, the number 2 in your code means it returns 2 chars right? I will have only one '/' but I will have N chars after it.

sagi Over a year ago

No, it will return all chars after it. @jax-p

Collectives™ on Stack Overflow

Get string after '/' character in SQL Postgres

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related