Ignore Blanks When Using Char(10)

Hello, I am having display issues when using Join Collect and Char(10).

=JOIN(COLLECT([Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), [Helper Site 1]@row + CHAR(10) + [Helper Site 2]@row + CHAR(10) + [Helper Site 3]@row + CHAR(10) + [Helper Site 4]@row + CHAR(10), @cell <> ""))

Results:

How do I get the blank to not display and have the 444 Site 4 to move up?

Find more posts tagged with

Accepted answers

Samuel Mueller

@MichaelO1 It would not stop, because they are separate, they are not nested, in this case.

All comments

Samuel Mueller

Unfortunately you are going to have to separate out your formula.

if([helper site 1]@row = "", "", [helper site 1]@row + char(10)) + if([helper site 2]@row = "", "", [helper site 2]@row + char(10))

something like that

MichaelO1

Hello, wouldn't that formula stop if helper site 1 is blank and not look at helper site 2, 3, 4, etc?

Samuel Mueller

@MichaelO1 It would not stop, because they are separate, they are not nested, in this case.

MichaelO1

Thank you Samuel it worked!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.