| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function to read text file; find string; delete same before import
2003
Need a VBA function to read text file; find string; delete same before import. The function should find all instances (there can be many) of: SELECT TO_CHAR(NET AMT|DOC_NUM|FIPC| the last line of the file REPORT COMPLETE In short, just the data please SELECT TO_CHAR(NET AMT|DOC_NUM|FIPC| 407.44|N6887008TORHMS5|D|22|AA|08| 2500.00|N6887008MDNC018|D|36|AA|08| -2500.00|N6887008MDNC013|D|36|AA|08| 2133.18|N6887008MDNC013|D|36|AA|08 -1004.93|N6887008WR82003|D|36|AA|08| SELECT TO_CHAR(NET AMT|DOC_NUM|FIPC| 407.44|N6887008TORHMS5|D|22|AA|08| 2500.00|N6887008MDNC018|D|36|AA|08| -2500.00|N6887008MDNC013|D|36|AA|08| 2133.18|N6887008MDNC013|D|36|AA|08 -1004.93|N6887008WR82003|D|36|AA|08| REPORT COMPLETE TIA any and all help greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Text File Import Cell | Excel Programming | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
| Import partial record from text file string | Excel Programming | |||
| Import partial record from text file string | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
