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

Eric Barro ebarro at verizon.net
Wed May 9 16:36:36 CDT 2007


It would be the same syntax in VB.NET except you lose the ; at the end. :) 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Ron Allen
Sent: Wednesday, May 09, 2007 2:24 PM
To: dba-vb at databaseadvisors.com
Subject: Re: [dba-VB] VB.Net - cut and trim

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




> 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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.6.6/794 - Release Date: 5/8/2007 2:23
PM
 




More information about the dba-VB mailing list