Hi. Hopefully this is a simple thing and you won't mind helping an old man whose mind isn't as sharp as it once was.
I have two files, the first with two fields, one containing known data, and the second empty. The second file also contains two fields, one that matches the first field in the first file, and the second contains data that I want to place in the first file's empty folder by matching the other fields. I would just combine the files with matching data except that the matching field in the first file actually contains multiple pieces of data separated by semicolons. What I hope to do is write a script in the first file that first grabs one piece of data from that field and then match it to the second file field, and then copy the other field's data into the first file's empty field. Hope this makes sense. Is this doable? Thanks, Charlie
