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

ShingoYano

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!

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.

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.