Charlotte Foust
cfoust at infostatsystems.com
Wed May 9 18:20:32 CDT 2007
You aren't exactly stacking methods, John, more like stacking objects. Each method involved is returning an object and that object shares in the methods of its class. So if you use substring, the result is a string object, and you then call the trim method of that object. Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, May 09, 2007 3:20 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] VB.Net - cut and trim Pretty much. That's one of the nice things about the .Net environment. And don't forget things like Split and Replace, which also exist in .Net for your listening pleasure. LOL Charlotte Foust -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Wednesday, May 09, 2007 2:58 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] VB.Net - cut and trim 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 _______________________________________________ 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