I have a group of people that submit information in excel format. I am creating a common report from these files.
The fields are all common however, the record fields vary quite a bit. The first field has 6 valid IDs that I need for a final report. I want to write a script to eliminate all the unnecessary records, but there is no common theme (blank cells etc.) Everyone does theirs different. The only commonality is the valid fields. I assume that I need to create a variable for those valid entries and then eliminate everything that is not valid. I have been attempting to do that, but have not had a lot of luck. I realize this is Filemaker 101, but does someone have a sample script they could share with me to show me how to do this?
Thanks in advance!