Page 1 of 1

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

Posted: Sun Jan 09, 2005 9:55 am
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

Posted: Mon Jan 10, 2005 8:27 am
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 |