Remove spaces while using concat

[Andyoye]

IP 2007

I have a text field who's value is based on :

concat(FieldA, " ", FieldB, " ", FieldC)

Question is: If FieldA and FieldB are empty, I end having blank spaces and
then value of FieldC. How can I put a condition or use substring to
eliminate the spaces?

tks

 

[Frederik Van Lierde]

I don't know if you tried your question, as I tried it and I don't
have you problem.

Concat deletes the spaces automatically

concat(field4, " ", field5, " ", field6)

Field4 and field 5 I tested with ' ' and '' , but gave a good result,
meaning without leading spaces

Frederik Van Lierde
http://SilversandsAssociates.wordpress.com

Twitter: http://Twitter.com/SilverSands_IT

 

[Andyoye]

here is my formula for "Login Field" textbox

concat("Reassign to: ", LoginNames_1, LoginName_2, LoginName_3,
LoginNames_4, LoginNames_5)

If i leave LoginNames_1,2,3 & 4 blank and assign a value to field5, I get
leadind spaces when i assign "login Field" value to a string (ComboNames)

XPathNavigator frmLoginNames = this.CreateNavigator();

string ComboNames =
frmLoginNamest.SelectSingleNode("/my:myFields/my:group12/my:Login Field",
this.NamespaceManager).Value;

 

[Andyoye]

I fig out.... I used normalized-space function..thx

 

[Shiva]

Hello,

If you use normalized-space function it will remove more than one space
characters. But it will keep one space character if there are more than one.