Trouble extracting values from a string in postgres

Question

I have a string X-99-XX-999 in postgres 9.6. I'm looking to extract XX. The XX is always between the second and the third hyphen. Can anyone please help?

what have you tried so far?

OriolAbril
– OriolAbril

2018-07-02 21:01:55 +00:00
Commented Jul 2, 2018 at 21:01 — OriolAbril
– OriolAbril, Commented Jul 2, 2018 at 21:01

klin · Accepted Answer · 2018-07-02 20:47:53Z

2

Use the function split_part()

select split_part('X-99-XX-999', '-', 3)

 split_part 
------------
 XX
(1 row)

From the documentation:

split_part(string text, delimiter text, field int)

Split string on delimiter and return the given field (counting from one)

answered Jul 2, 2018 at 20:47

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

Trouble extracting values from a string in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related