Best way to perform batch edits in a TM’s custom field?

Question

Hello, 
 I want to perform global edits in a custom field (text, allows multiple values) that's included in a large TM. 
 Changes such as this: from &ldquo;R1_C1_AS&rdquo; to &ldquo;R1_C1_AS_ANOC&rdquo;. The change will always occur after the last &ldquo;_&rdquo;. Simple enough when there is only one value but most TUs have a number of those values. 
 I suppose I should consider the use of regex in batch edits but I wonder if there is any other, perhaps simpler, way to proceed. 
 Any recommendation you may have would be greatly appreciated.

Paul Filkin · Answer

Gilberto V.V. 
 
Actually it's pretty easy using the SDL Data Protection Suite from the appstore. This will allow you to export all of your custom field values to excel. Then you can either manipulate the values in Excel, or siply copy paste to a text editor where you can make the changes using regex or whatever. Then the Excel file can be imported back in to update the values in the TM 
 
 appstore.sdl.com/.../ 
 
The tool was designed for another purpose but it has some very useful features you can take advantage of here particularly around the manipulation of custom and system fields.

Trados Studio > 1. Trados Studio

Best way to perform batch edits in a TM’s custom field?