remove space while concatenating more than 2 fields...

[singhcv123]

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]

Use something like this -

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

[tamilarasu]

Hi Virendra ,

Simply try,

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

[jagan]

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]

try like this

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

[Anonymous]

Hi, try this:

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

You will remove start space and double spaces.

Regards!

[sunny_talwar]

Very Nice jagan‌ and others. Thanks for sharing this