View Single Post
Old 09-18-2010, 04:40 PM   #50
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by gwk View Post
It seams to me that the questions comes down to the following.

Do we need:
- a one to one field copy - and remove some not needed characters
- do we need to combine fields (a many to one copy) - and remove some not needed characters

At this point in time, I cannot seam to find an useful example for the usage of combining fields. Something like this would only occur for something like this:
- series contains: AuthorLastName
- author contains: AuthorFirstName
In this situation you would like to combine both fields to complete the author field.
In my opinion this situation is rare.
You can solve this problem as long as the field copy can be run in append mode to append a source field to a destination field's contents. There's no need to have multiple field -> single field in a single step as long as you can do it in multiple steps for the rare case you might want this.

Charles already has the "remove unwanted characters" built in the regex processing. All we need is two pulldown boxes for existing field references, one labeled "Source Field" and one "Destination Field" and a checkbox for overwrite/append. The code just has to check for compatible field types for the overwrite/append operation.
Starson17 is offline   Reply With Quote