JWColby
jwcolby at colbyconsulting.com
Wed May 9 16:57:51 CDT 2007
It is interesting that you can stack methods like that. Substring and trim are both methods of the string object. This implies that the methods are processed left to right and the result of the left is passed into the right. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of David McAfee Sent: Wednesday, May 09, 2007 5:48 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] VB.Net - cut and trim On 5/9/07, Ron Allen <chizotz at mchsi.com> wrote: > > John, > > In C#, you can do this in one line, no need to use the stringbuilder > class: > > output = recordValue.Substring(startPosition, resultWidth).Trim(); > > If the recordValue = "abcdefghijklmnop", startPosition = 5, and > resultWidth = 6, output would be "fghijk". > > Ron Well according to http://www.carlosag.net/Tools/CodeTranslator/Default.aspx they translate it as such for VB: output = recordValue.Substring(startPosition, resultWidth).Trim > I am looking at how to do in VB.Net what in VBA would be str = > > trim(mid(str,intStartPos, intLen)) > > > > I can do this (I think) in two steps using: > > > > private mstr as string > > mstr = lstrRecord.SubString(intStartPos,intWidth) > > mstr = mstr.Trim(mstr.ToCharArray) > > > > Given what I know about VB.Net (not very darned much) is this the > > best > way? > > I see where the string builder can do the substring part but it does > > not have a trim method. > > > > John W. Colby > > Colby Consulting > > www.ColbyConsulting.com > > > > _______________________________________________ > > dba-VB mailing list > > dba-VB at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-vb > > http://www.databaseadvisors.com > > > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > > _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com