I am running Monarch 8.02 and having some difficulty with capturing inconsistent data. I thought of using the Floating Trap option, but it does not work.
The data below is what I am trying to capture, but sometimes certain data are blank. Take for example the Edit Number in the last line or the Date Created is blank. When there are blank data the whole line shifts to the left. I tried using the Floating Trap with “/”, but that did not work. Any suggestion is greatly appreciated.
EDIT SUMMARY REPORT
DATE:12/07/2006 PAGE: 145
FILE: NEICNEICST D.DBF
Edit Date Date
Number Created Modified Disabled Description
720 / / 10/20/2006 No BILLED Set claims to a billed status
227 10/14/2004 1/14/2006 No NOPAY Change carrier to NOPAY
893 8/23/2006 8/23/2006 No |RESUM BIL Resummed Total Charges
721 / / / / No SKIP EDITS Skip the remaining edits
953 2/5/2003 2/5/2003 No SPOT Remove carrier if equal to SPOT
950 2/5/2003 2/5/2003 No SPOT Check for prompt pay indicator
951 2/5/2003 2/5/2003 No SPOT Strip SPOT from cert ID
/ / / / No CARRIER Carrier assigned to primary claim for Accubill