remove characters from the strings matching pattern postgresql

Question

I have some text elements in the column that have a character "|" and the rest right after it I need to get rid of:

campaign
abc
fdg|3234
dfr|4567

I want it to look like:

campaign
abc
fdg
dfr

I tried:

select replace (data_2_crm.campaign, '_|_', '' ) from data_2_crm
select trim (trailing '.*|' from campaign) from data_2_crm
select trim (trailing '%|' from campaign) from data_2_crm

It didn't work. Please help!

Does this answer your question? Regex to remove all characters after the pipe excluding newline — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Oct 8, 2020 at 10:41

Tim Biegeleisen · Accepted Answer · 2020-10-08 10:43:21Z

1

Use a regex replacement on the pattern \|.*$:

SELECT
    campaign,
    REGEXP_REPLACE(campaign, '\|.*$', '') AS new_campaign
FROM data_2_crm;

Demo

answered Oct 8, 2020 at 10:43

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2020-10-08 10:43:10Z

1

Use split_part():

select t.*, split_part(campaign, '|', 1)
from data_2_crm;

answered Oct 8, 2020 at 10:43

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Collectives™ on Stack Overflow

remove characters from the strings matching pattern postgresql

2 Answers 2

Demo

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related