View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] ymcasatx@gmail.com is offline
external usenet poster
 
Posts: 2
Default Importing parts of a text file into Excel

Hi everyone,

I'm trying to import a text file that is in the following format:
------------------------------------------
Bunch of Junk
------------------------------------------

R01 27 $99.00 DOE, JOHN 000000000 1234567890
028-000058927 (7713021)
R01 -REASON UNKOWN -


R08 27 $99.00 DOE, JANE 000000000 1234567890
033-000064075 (7713057)
R08 -REASON KNOWN 4443 -



R01 27 $99.16 DOLL, BETSY. 000000000 1234567890
033-000075124 (7713131)
R01 -REASON UNKNOWN -
-----------------------------------------
More Junk
-----------------------------------------

I need to import the data in the example with the following criteria:
- ONLY lines with R01 (so the R08 line would be skipped)
- Need the amount in a column
- First and last name (separated)
- The routing numbers (the 9 digit number that is zeroed out)
- The account numbers (variable length)
- The 13 character string that is below the name

I've looked around and think that macros are the best way to do it.
problem is that I have no understanding as to where to even start.

so anyone that could help me with this I'll greatly approciate it !

Thank you for all your help..