[theducks]

Originally Posted by mike.katina

Hello Everyone, I've come up to another wall...
Been searching for several hours but did not find any exact trouble

I have several thousand reports that have something I need to be removed from the "Series" column. I tried several different approaches using the advance search tool, really too many to list since they didn't work.

in the "unmodified" [Series] column, which I use a lot to list chronologically the reports there are a series of characters which I just plainly want to be removed as they are useless, ex as follows;

Fall 2011: 10.12.2011 list of required machinery maintenance to be covered
Fall 2011: 10.14.2011 Pickup #1, 2, 3, 4 oil changed and greased
...
etc etc etc ...

no need to put more, so what I need is to just plainly delete, in this specific reference, the characters [Fall 2011: ]

so as to have this as a result:

10.12.2011 list of required machinery maintenance to be covered
10.14.2011 Pickup #1, 2, 3, 4 oil changed and greased
...

but only in the [Series] column.

is this something possible or should I start doing them all 1 by 1?

TY all

Should be doable with Bulk mode MDE Search and replace
Select books to be fixed: Tap 'E' (bulk mode): switch to S&R tab
REGEX MODE (on right)

NOT TESTED
Search field SERIES:
search for

\[.+?\]:\s*(.+?)

replace with \1

Validate the results are good in the test results THERE IS NO UNDO once you click OK

Since the destination is the same, no entry is needed