• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

496

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
Community Expert ,
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.

Votes

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

Votes

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
Community Expert ,
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

Votes

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.  

Votes

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
Community Expert ,
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

Votes

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.

Votes

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
Community Expert ,
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"

Votes

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