how can I display multiple spaces? " "+" "+" ", Char(32) + Char(320 etc...?

I am trying to create concatenated text with multiple continuous "spaces" so I can map that in PDF in one go, like below.

ID: XXXXXXXX1 Name: First Last ......

ID: XXXXXXXX2 Name: First Last ......

With the formula below, " " will endup with single space as well as Char(32)+Char(32).

"ID: "+[ID]@row + " "+"Name: " + [Name]@row

Does anyone has an idea for this?

Thanks!

Find more posts tagged with

Accepted answers

Gia Thinh

I found that adding a CHAR(32)- space with a CHAR(127)-delete will make the continuous spaces work. Try at your end.

All comments

Gia Thinh

@ShingoYano,

Just add the multiple spaces "____" to your formula instead of one single space "_"

ShingoYano

I have tried, but multiple spaces like this,

But when save, it transforms into single space.

Gia Thinh

I found that adding a CHAR(32)- space with a CHAR(127)-delete will make the continuous spaces work. Try at your end.

ShingoYano

Thanks @Gia Thinh, it worked! Bit lengthy, does not much matter.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.