Reply To: Find Duplicates and Delete

Product Compare Forums Multi-Edit User Created Macros Find Duplicates and Delete Reply To: Find Duplicates and Delete

#5957
Ernie Zapata
Participant

This macro seems to remove all blank lines and does not appear to handle lines beginning with tab characters. Take for example the following data:[code:3gjsmh0w]
This is not a test.
This is not a test 0.

This is a test.
This is a test.

This is not a test 1.
This is not a test 2.
This is not a test 3.
This is not a test 4.

This is a test.
This is not a test 5.
This is not a test 6.
This is not a test 7.
This is not a test 8.

This is a test.
[/code:3gjsmh0w]

I have attached the data file as a zip file.

All blank lines in the example have no white-space characters, just blank lines. Those lines with the text “This is a test.” begin with a tab character, not spaces.

Running the macro against this sample data result in all blank lines being removed and none of the duplicate “<tab>This is a test.” lines being removed.
data.zip