Select a part of a string - Postgresql

Question

I have a column with strings like '006_THR'; '1003_ER'; '100_THREE' and i want to put all string before "_" in a column and all string after "_" in a other column.

 col         col1     col2
006_THR      006       THR
1003_ER      1003      ER  
100_THRE     100       THRE

Thank you!

Gordon Linoff · Accepted Answer · 2020-03-03 18:08:29Z

3

How about split_part():

select col, split_part(col, '_', 1) as col1, split_part(col, '_', 2) as col2
from t;

answered Mar 3, 2020 at 18:08

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

2 Comments

scH Over a year ago

I struggled with substring and strpos. I didn't know about split_part. Thank you!

Gordon Linoff Over a year ago

@Lucian . . . If you like split_part() you'll just love regexp_split_to_table() and regexp_split_to_array()!

Collectives™ on Stack Overflow

Select a part of a string - Postgresql

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