InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 00:01:45 GMT20http://forum.strataframe.net/FindPost22326.aspxHi,</P><P>is it possible to write a FormatString that only puts a whitespace in case the next field is not empty ?</P><P>My FormatString looks like this:</P><P>{1} {2}, {5}-{3} {4}</P><P>1= Adressfield1, 2=Adressfield2, 5=CountryShortcut, 3=postal code, 4=city</P><P>however, the field Adressfield2 may or may not have a value, and thus if it doesnt have a value,</P><P>the whitespace infront of it needs to go.</P><P>any ideas ?</P><P>thanks.Thu, 12 Mar 2009 09:25:42 GMTPhilipp Guntermannhttp://forum.strataframe.net/FindPost22333.aspxi see</P><P>thanks.Thu, 12 Mar 2009 09:25:42 GMTPhilipp Guntermannhttp://forum.strataframe.net/FindPost22330.aspxYou will have to take this into account yourself.&nbsp; We have a DataHalpers static (shared) class that we have do all of this for us.&nbsp; SO when we have an address or name, we pass it over to these methods and it takes care of it for us.&nbsp; If we need it in a list, etc, then we will either handle the RowPopulating event or create a custom property on the BO that calls this method for us.</P><P>[codesnippet]DataHelpers.FormatAddress(Add1, Add2, City, StateOrProvince, Postal)[/codesnippet]Thu, 12 Mar 2009 09:10:53 GMTTrent L. Taylor