[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
>