Here's a screenshot of where I stand, showing the situation on the main screen, with what I get on the Search & Replace. I can isolate either the correct value or the incorrect value from the authors field and have it show up in the right-hand column of the Test Result section, but it doesn't seem to write correctly.
I suspect that's because there's nothing in the Replace With dialogue field.
What I would like is to have the incorrect value show up on the left (I can achieve that) and nothing on the right, meaning that the icorrect value would be replaced with NULL. (YEs, I tried a space but that didn't work either.)
I guess what I'm asking, in a nutshell, is how do I delete a numbered member of a multi-value field?
|