topic Re: remove space while concatenating more than 2 fields... in QlikView

remove space while concatenating more than 2 fields...

singhcv123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

TRIM([ Title]) & ' ' & TRIM(Initials) & ' ' &TRIM([ Name])

as per above concatenation we are facing space issue while 1 of the field is missing like Title or Initials.

LIke examle :

Alex D voyger ---------this is right out come.

but if some one who don;t have either title or initial than coming doule space instead of single spcae.

Like ::::Without title

' D cow'

Like :: without intital

"Mr Tad" double space between title and name ...

please suggest.

Digvijay_Singh — Thu, 22 Sep 2016 05:54:12 GMT

Use something like this -

TRIM([ Title]) & if(len(Title)>0,' ') & TRIM(Initials) & if(len(Initials)>0,' ')&TRIM([ Name])

tamilarasu — Thu, 22 Sep 2016 05:55:08 GMT

Hi Virendra ,

Simply try,

Replace( [ Title] & ' ' & Initials & ' ' & [ Name] , ' ' , ' ' )

jagan — Thu, 22 Sep 2016 06:19:12 GMT

Hi,

Simply use Replace() to convert two spaces to single space like below

Replace([ Title] & ' ' & Initials & ' ' & [ Name] , ' ', '')

Replace([ Title] & ' ' & Initials & ' ' & [ Name] , 'Give double space here', 'Single space')

Regards,

jagan.

avinashelite — Thu, 22 Sep 2016 07:20:25 GMT

try like this

replace(filed1&filed2&filed3,' ','')

Anonymous — Thu, 22 Sep 2016 07:40:00 GMT

Hi, try this:

Trim(Replace(TRIM([ Title]) & ' ' & TRIM(Initials) & ' ' &TRIM([ Name]),' ',' '))

You will remove start space and double spaces.

Regards!

sunny_talwar — Thu, 22 Sep 2016 09:24:42 GMT

Very Nice jagan‌ and others. Thanks for sharing this