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

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

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

Postby 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

Richard

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

Postby 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

$0

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

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


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 5 guests