View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Red Red is offline
external usenet poster
 
Posts: 48
Default Alternative to ...For Input As #1

I need to open FileA, read through it line by line, parse the data, and
output line by line to FileB. (Both text files)

I'd usually use

Open FileA For Input As #1
Open FileB For Output As #2
Do While Not EOF(1)
Input #1, F1, F2, F3
...various code...
Print #2, F4, F5, F6
Loop
Close #1
Close #2

This works fine with csv files. However, one of the files I need to parse
is + delimeted. Example:

11+6146348+DOC+997+NEW+20041011+124155+REPRINT+

Is there a simple alternative to the above that will work with +? Or will I
have to use

Line Input #1, textLine

and write code to chop up textLine each loop. The fields in FileA are
variable lengths, and the records are longer than the example shown above.
Any suggestions that will save me a lot of time?

Many TIA,

Red.