Replace all text within a field

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

MSIAC
Posts: 1
Joined: Wed Dec 07, 2005 9:02 pm
Location: Brussels

Replace all text within a field

Postby MSIAC » Thu Dec 08, 2005 12:26 am

Hello all,

I have a number of databases which are currently being migrated to another system but require a bit of reworking before the move.

I cannot seem to figure out how to replace the text that falls between the field names with "Citation". The text that follows the field name is always different.

.DOC_TYPE. (field name)
Technical Report (data)
.SUPP_NOTES. (field name)

Thank you

Michael Longie
Brussels

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

Postby DataMystic Support » Tue Dec 13, 2005 11:47 am

Hi Michael,

Try this perl pattern:

(\.DOC_TYPE\.Citation).*(\.SUPP_NOTES\.)

Replace with

$1 new text
$2
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: Yahoo [Bot] and 4 guests