Hello! I am trying to import a difficult PDF that spans several hundred pages. I am working with a data set in which my base layer contains five columns (see the example image). Overall, each of the five columns contains various data and blank fields. However, blank fields are a continuation of the previous record. Because all five fields may be blank or have data, I am having difficulty setting a trap. I have set my trap using spaces, which is not ideal. However, because of this, my base layer captures blank lines in the report. This is problematic because the base layer attributes for blank cells are set to “use value from previous record.” Therefore, my blank lines are populating as records based on previous records; these extra records are sometimes duplicates and other times a hodgepodge of previous records because there are other layers in the document that append to the base layer. There is a blank row on each page of the document; therefore, it is not feasible to manually exclude each line from the output. Do you have any suggestions on how I can exclude from the base layer rows that are entirely blank?
Last seen: 6 months 1 hour ago
Joined: 06/07/2023 - 17:02