Hi Charlie, I’d be happy to help you with this if you’d like to send me your file(s) at [email protected]<mailto:[email protected]> . Feel free to truncate and/or obfuscate the data.
Jeff On Apr 23, 2023, at 6:21 AM, Charles Hartley <[email protected]> wrote: 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]<mailto:[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
