REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.


Before;

|aShakespeare, William,|d1564-1616.


Regex;

REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')


After;

Shakespeare, William, 1564-1616.

Tsohost UK Web Host Review & Promo Discount Code
Ubuntu Remotely Connect to MySQL Database
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
July 15, 2020

Captcha Image

Latest Comments

Guest - Susan Hermiston Virtual Hosts
October 7, 2015
Wow 747 just blew me away. Sorry not a tech person at all!! But I still love you!! Rock on!!?
Guest - Johmny Invisible Mouse Cursor Ubuntu & Synergy
September 2, 2015
Glad I was ble to help!
Guest - Kristian Falk Invisible Mouse Cursor Ubuntu & Synergy
September 1, 2015
Thank you for this! Had the exact same problem. I almost went crazy.