i am exporting a union query to a text file. i expect the cursor to be at the end of my data. instead, when i open the text file, the cursor is 2 rows away from the last row (with data). the export creates blank rows. the blank rows cause an error when i upload the text file to another program.
what do i use to remove the blank lines/empty rows?
what do i use to remove the blank lines/empty rows?