David McAfee
davidmcafee at gmail.com
Wed May 9 16:48:30 CDT 2007
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 > >