View Single Post
Old 03-25-2020, 07:23 PM   #7
sasilk
Connoisseur
sasilk began at the beginning.
 
sasilk's Avatar
 
Posts: 75
Karma: 14
Join Date: Jun 2008
Location: Australia
Device: iPad Pro 12"; Kindle Paperwhite
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?
Attached Thumbnails
Click image for larger version

Name:	Screen Shot 2020-03-26 at 10.02.54.jpg
Views:	134
Size:	922.7 KB
ID:	177910  
sasilk is offline   Reply With Quote