[dba-VB] VB.Net - cut and trim

Charlotte Foust cfoust at infostatsystems.com
Wed May 9 17:20:12 CDT 2007


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





More information about the dba-VB mailing list