Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |