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 <*> 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/
