Dean, That worked beautifully without having to take it into Excel and reformat. That function is going in my library - thanks for taking the time.
Ronda On Mon, 28 Feb 2005 16:34:34 -0500, Dean Fiala <[EMAIL PROTECTED]> wrote: > > Ronda, > Try this. It will scoot through the string and only add non-space > strings. The one thing to note is that it will split a person's name > also, so if you get someone with a middle name, you will get more > items back in the arraylist. > > Private Function ParseLine(line as string) as ArrayList > Dim al as ArrayList = new ArrayList() > Dim tmp() As String > Dim i As Integer > tmp = Regex.Split(line, "[\s]") > For i = 0 To tmp.Length - 1 > If tmp(i).Length > 0 Then > al.Add(tmp(i)) > End If > Next > Return al > End function > > > On Mon, 28 Feb 2005 15:23:29 -0600, Ronda K <[EMAIL PROTECTED]> wrote: > > > > Jason, > > > > If I do an actual import and map the fields you are right I could come > > up with a format that I could read. Do you see any way to parse the > > text file without importing into Excel - I was trying to avoid that > > step for the end user. They just wanted to upload and process. > > Curious though that you saw the pattern (e.g. field on 16 characters) > > - I guess I have been looking at this file too long and didn't see the > > pattern so I will reexamine it ... if that is the case then I can just > > parse at specific characters. > > > > I am still interested in knowing though if one can parse and just pick > > up the next character after a string of white space .... > > > > Ronda > > > > > > On Mon, 28 Feb 2005 21:16:51 -0000, Jason Handby <[EMAIL PROTECTED]> wrote: > > > > > > Hi Ronda, > > > > > > It looks to me like your fields are at fixed column positions -- i.e. the > > > first field starts at character 1, the next field starts at character > > > 16... > > > So I think what you need to do is to select "fixed-width" as your format > > > type when you open the file in Excel. You should then be able to drag some > > > little sliders around in the import dialog to show Excel where each column > > > of data begins and ends. > > > > > > I've just copied the data from your email, pasted it into a text file and > > > read it into Excel, and it was very easy. (I'm using Excel 2003 but I'm > > > pretty sure older versions will cope with this too.) > > > > > > Jason > > > > > > _____ > > > > > > From: Ronda K [mailto:[EMAIL PROTECTED] > > > Sent: 28 February 2005 15:53 > > > To: [email protected] > > > Subject: [AspNetAnyQuestionIsOk] Parsing Text Files > > > > > > I am dealing with a text file that contains shipping information it is > > > coming out of a very archaic system. The file looks something like > > > this: > > > > > > RPS AIR-PP SL29799EA DEBBIE RUSKOWSKY 23322 > > > 3.00 .00 055108800099191 996060 86658 > > > RPS AIR-PP SL33098 MICHAEL DEMERS 80631 > > > 2.00 .00 055108800099153 997340 86658 > > > RPS AIR-PP SL33103 PASITHORN SUWANABOL 53705 > > > 4.00 .00 055108800099221 998460 86658 > > > RPS AIR-PP SL33104 LISA PAYTON 33133 > > > 3.00 .00 055108800099207 998470 86658 > > > RPS AIR-PP SL33108 PHILIP ALVAREZ-CORREA 03741 > > > 3.00 .00 055108800099214 998630 86658 > > > > > > If you open it in Excel each line reads in one cell indicating that > > > there is not a tab character in there. This is confirmed when I try > > > to create an array and break it on chr(32). I have also tried to > > > create an array and break it on chr(9) but that is not working either > > > - I get way too many fields. How do I specify to break on the next > > > non-space character? I need to get out the shipping method, order # > > > and tracking # when it is all said and done. > > > > > > TIA, > > > > > > -- > > > Ronda Pederson > > > MVP ASP.Net > > > > > > Yahoo! Groups Sponsor > > > > > > ADVERTISEMENT > > > > > > <http://us.ard.yahoo.com/SIG=1296ve9cq/M=298184.6018725.7038619.3001176/D=gr > > > oups/S=1705006764:HM/EXP=1109692416/A=2593423/R=0/SIG=11el9gslf/*http://www. > > > netflix.com/Default?mqso=60190075> click here > > > > > > <http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S= > > > :HM/A=2593423/rand=880398972> > > > > > > _____ > > > > > > Yahoo! Groups Links > > > > > > * To visit your group on the web, go to: > > > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > > > > > * To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > <mailto:[EMAIL PROTECTED] > > > e> > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > > Service > > > <http://docs.yahoo.com/info/terms/> . > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > -- > > Ronda Pederson > > MVP ASP.Net > > > > Yahoo! Groups Links > > > > > > > > > > > > -- > Dean Fiala > Very Practical Software, Inc > http://www.vpsw.com > > > Yahoo! Groups Links > > > > > -- Ronda Pederson MVP ASP.Net Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
