logic query : How do I replace commas with pipes b/n [,,,]

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
blavatsky
Posts: 1
Joined: Sun Jan 09, 2005 9:39 am

logic query : How do I replace commas with pipes b/n [,,,]

Post by blavatsky »

How do I replace ONLY commas between closed brackets '[' and ']' with with pipes

eg change
line2002, bonne, good, [cat, dog, mouse ], keep, now;

to read as

line2002, bonne, good, [cat| dog| mouse], keep, now;

any help is appreciated

Richard
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

Hi Richard,

Use a search/replace as a restriction.

Search for EasyPattern

[ '[', 1 or more char, ']' ]

replace with

$0

Inside this filter, place a search and replace of , with |
Post Reply