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.

Rate this blog entry:
Ubuntu Remotely Connect to MySQL Database

Comments

 
No comments yet