Hollis,Virginia
HollisVJ at pgdp.usec.com
Wed Sep 24 07:57:51 CDT 2003
This is a real challenge... Is it possible to search a field for certain text, remove the word for placement in another field? We have a part description that lists the document number in the description. The document numbers are all the same length and all start with DS-, (ex: DS-MDD-15987-001). But the document number might be anywhere in the description. The document number needs to be separated out into a field by itself. There are over 3,000 records & I really don't want to sit here for days doing a copy & paste to move the number to a new field. Any ideas? Or can this be done at all? Virginia