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
Replace all text within a field
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Hi Michael,
Try this perl pattern:
(\.DOC_TYPE\.Citation).*(\.SUPP_NOTES\.)
Replace with
$1 new text
$2
Try this perl pattern:
(\.DOC_TYPE\.Citation).*(\.SUPP_NOTES\.)
Replace with
$1 new text
$2
Regards,
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
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