Maarten, thank you for responding. I had thought of separating the entries into separate fields, but I still need to compare fields in separate files.
Perhaps if I explain in more detail what I need to do, it may be helpful. I have in one file 1,745 records, each containing two fields: (1) names of land plats, and (2) reference numbers for the plats. In the second file containing over 4,000 records I have a field that contains names of people, and a second field that lists all the land plats where that person's name is found, separated by semicolons. This field contains a minimum of two entries, up to one containing 56 entries (separated with semicolons). What I had hoped to do was use a script to capture each entry from file 2, field 2, and then compare it to the records in file 1, field 1, and upon finding a match copy the reference number from file 1 back to file 2. Thanks for your patience. Charlie On Sun, Apr 23, 2023 at 2:13 AM Maarten Sjouw <[email protected]> wrote: > Hey Charlie, > > You can use lookup for what you want to do, however I would not do it that > way, no need for scripting at all, just export the second file to a CSV > file, use a text editor and check which separator is used between the first > and second piece of data and replace the semicolon with that. > sample: > "field1","field2-part1;part2;part3" > Change this to: > "field1","field2-part1","part2","part3" > No make sure you have enough fields in your file you want the data to be > moved into and import the just created CSV text file. > > Kind regards, Maarten. > > On 23-4-2023 3:53, Charles Hartley wrote: > > 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 > > >
