PostgreSQL: Replace string from specific position to end of string

Question

I have the following string:

String 1: abcde?dafsdfdsfsd
String 2: absdfcde?dafsdfdsfsdsfdsdfd

Want to remove anything after "?"

Expected output:

String 1: abcde
String 2: absdfcde

klin · Accepted Answer · 2017-05-03 11:16:14Z

3

Use split_part(), e.g.:

with my_data(col) as (
values
    ('abcde?dafsdfdsfsd'),
    ('absdfcde?dafsdfdsfsdsfdsdfd')
)

select split_part(col, '?', 1)
from my_data;

 split_part 
------------
 abcde
 absdfcde
(2 rows)

answered May 3, 2017 at 11:16

klin

123k15 gold badges240 silver badges262 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL: Replace string from specific position to end of string

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