Replace with IsNull or ''

[#1]

I am currently concatenating two fields and adding a space

trim([Opportunity owner Firstname]& '  ' &[Opportunity owner Surname]) as [Opportunity Owner],

I'd also like to if either the Firstname or Surname is '' or Null to null the [Opportunity Owner],

Could someone point me in the right direction please?

[SunilChauhan]

(

if(isnull([Opportunity owner FisrtName]),' ',[Opportunity owner FisrtName])

& '  ' &

if(isnull([Opportunity owner Surname]),' ',[Opportunity owner Surname]))

you can also change ' ' to any thing else like  'NULL'

hope this helps

[#3]

Will this remove the space i have added in the concatenate?

[SunilChauhan]

in that case use below code

trim(

if(isnull([Opportunity owner FisrtName]),' ',[Opportunity owner FisrtName])

&

if(isnull([Opportunity owner Surname]),' ',[Opportunity owner Surname]))

[jagannalla]

Hello,

Try this code. Hope it helps you.

If([Opportunity owner Firstname]& '  ' &[Opportunity owner Surname]='',Null(),Trim([Opportunity owner Firstname]& '  ' &[Opportunity owner Surname])) as [Opportunity Owner]

[#6 · Accepted solution]

Hi Lewis,

try with this:

if (IsNull([Opportunity owner Firstname]) or trim([Opportunity owner Firstname])='' or IsNull([Opportunity owner Surname]) or trim([Opportunity owner Surname])='' , null(), trim([Opportunity owner Firstname]) & ' ' & trim([Opportunity owner Surname])) as [Opportunity Owner]

[#7]

Excellent, thats worked perfectly... Thank you all for your help!