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: 2278
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, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests