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

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

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

Post by blavatsky » Sun Jan 09, 2005 9:55 am

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


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

Post by DataMystic Support » Mon Jan 10, 2005 8:27 am

Hi Richard,

Use a search/replace as a restriction.

Search for EasyPattern

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

replace with


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

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply