FAQ 2218: Grid - Copy to Clipboard shows blank rows in between EEs

Problem: Hi, I recently tried to view, grid, copy to clipboard but when I copied over to excel it had random blank rows in my copied data. It seems to only be occurring in this exact case because I tried another case and it worked fine (no random blank rows). The export feature worked fine in this case but I am used to copying and pasting from clipboard.

Solution: You mentioned that the information is inserting blanks. Review the individuals preceding or next following the blank rows, there is some sort of binary data (an invisible space) that can cause this sort of scenario. The fix is as follows: This behavior appears when binary invisible characters (sometimes a space) are present usually in the NAME field at the very end. But I've seen this in Notes as well (where it appears a RETURN may have been logged in there, click END and DELETE to remove). You can see who has the problem where you see the breaks in your extract. Go to this person's record listed in your file and manually fix them one by one this can be done in the grid (sometimes even easier). You will need to hit the delete button (not the backspace). Sometimes you are not able to see a space or binary data, in some cases, I completely delete the contents of the name field and reinput it. Hit the end key and delete and it should keep the name but remove the binary invisible data. Additionally, if the plan is large you can consider exporting via VXF and importing via VIF after fixing the fields for the blanks in excel.