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
October 1, 2020

Captcha Image

By accepting you will be accessing a service provided by a third-party external to https://www.johnnyshongo.com/