<div>
Thanks for the help. &nbsp;This does only get rid of the last &quot;,&quot; &nbsp;but is heading in the right direction.
</div>


Thanks for the help.  This does only get rid of the last ","  but is heading in the right direction.

<div>
<div class="content wysiwyg-content">
I have to concatenate 5 fields into one string to create an address that is entered into one field in a database. &nbsp;When not all of the fields are entered, I get commas at the end of the string, i.e. &quot;555 North Ave, , , &quot;&nbsp; &nbsp;How can I removed these before saving? &nbsp;It is not a matter of saving to different fields...I am working with old code and old tables that already have thousands of addresses that were saved to one field and I cannot change that. &nbsp;I also cannot require all address fields have data. &nbsp;I just want the save to the one address field as clean as possible. &nbsp; Thanks for your help in advance.
</div>
</div>


I have to concatenate 5 fields into one string to create an address that is entered into one field in a database.  When not all of the fields are entered, I get commas at the end of the string, i.e. "555 North Ave, , , "   How can I removed these before saving?  It is not a matter of saving to different fields...I am working with old code and old tables that already have thousands of addresses that were saved to one field and I cannot change that.  I also cannot require all address fields have data.  I just want the save to the one address field as clean as possible.   Thanks for your help in advance.

vb.net remove commas at end of address if not all fields are entered

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,