Replace all text within a field

[MSIAC]

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

[DataMystic Support]

Hi Michael,

Try this perl pattern:

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

Replace with

$1 new text
$2