yazzy10
02-08-2019, 03:29 AM
Hi
I am new to VBA and i require some help to run through a large text file to get specific data from the file.
I am looking to extract the data with the following headers BUT where Account read method should only = ESTIMATED
Name pinnumber,Manufacturer Job Serial Number,Account End Value,Account Entry Date,Rollover Flag,Account Read Type,Account Read Method,ID
Are you able to write me a code which I can use?any help would be really appreciated.
Thanks in advance.
Example of the test file
Name pinnumber,Manufacturer Job Serial Number,Account End Value,Account Entry Date,Rollover Flag,Account Read Type,Account Read Method,ID510PR,2133355,72148,2017-04-01,0,G,ESTIMATED,3005482731S1X
I am new to VBA and i require some help to run through a large text file to get specific data from the file.
I am looking to extract the data with the following headers BUT where Account read method should only = ESTIMATED
Name pinnumber,Manufacturer Job Serial Number,Account End Value,Account Entry Date,Rollover Flag,Account Read Type,Account Read Method,ID
Are you able to write me a code which I can use?any help would be really appreciated.
Thanks in advance.
Example of the test file
Name pinnumber,Manufacturer Job Serial Number,Account End Value,Account Entry Date,Rollover Flag,Account Read Type,Account Read Method,ID510PR,2133355,72148,2017-04-01,0,G,ESTIMATED,3005482731S1X