Data Merge not deleting blank lines

Participant ,
Jun 01, 2021 Jun 01, 2021

Copy link to clipboard

Copied

Running the latest CC ID version.  This began happening on my last 2 data merges for envelopes from a .csv file.  I have the "Remove Blank Lines" box checked for the merge.  Attaching a pic of the hidden characters, I think it looks right, but maybe I am missing something.

 

TOPICS
Bug

Views

223

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 01, 2021 Jun 01, 2021

Copy link to clipboard

Copied

For a line to be considered blank it must have no information from return to return, if you use forced line breaks it is not concidered blank. (It probably should havve read remove empty paragraphs to be entirely correct in the preference.) If it is the names the space between first and last will mean it is not empty.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 09, 2021 Jun 09, 2021

Copy link to clipboard

Copied

Did not solve

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 09, 2021 Jun 09, 2021

Copy link to clipboard

Copied

Do you have a test file? And could you show extract of the data file (a couple of example lines) and the result?
You are not giving much to help us help you, you said you have this checked.
You have no data what so ever in the lines that should be removed? (not a tidle or even a space)

Screenshot 2021-06-09 at 19.23.33.png

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 09, 2021 Jun 09, 2021

Copy link to clipboard

Copied

Here are the files.  

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 09, 2021 Jun 09, 2021

Copy link to clipboard

Copied

But isnt this a space character? I susspect the line that is not removed has that space.Screenshot 2021-06-09 at 22.31.19.png

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 09, 2021 Jun 09, 2021

Copy link to clipboard

Copied

Yes that is a space, as that line is First name <space> Last name.  So when there are 2 lines of names instead of one it works, but only one name or one address line it does not delete the Blank Line.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jun 10, 2021 Jun 10, 2021

Copy link to clipboard

Copied

LATEST

So it is behaving as designed a space is a character. therefore the line is not empty (to a computer). You will have to add a find/change where you find a space+return and replace with nothing.
The alternative is to preprocess the data so that "First" space "Last" becomes "First Last"

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines