-
I load a text-based file into an invisible TextBox.(Lets call it TextBox1). I then need to read the information from TextBox1 one line at a time, then pass that line to another invisible TextBox (TextBox2), where i process the information in that line. Then i need to be able to jump to the next line in TextBox1 and repeat this till the last line in TextBox1. I will need to do certain calculations on it such as total call, longest call, avg_call length.
The file looks something like this:
20000930,01:57:37,007,RING dealer <no Caller ID> -> <no Called ID>
20000930,01:57:59,007,HANG
20000930,01:57:59,007,END 22
20000930,02:01:16,008,RING dealer <no Caller ID> -> <no Called ID>
20000930,02:01:40,008,PROMPT T/O afnInputZip 501
20000930,02:01:40,008,HANG
20000930,02:01:40,008,END 24
20000930,02:48:51,009,RING dealer <no Caller ID> -> <no Called ID>
20000930,02:49:08,009,HANG
20000930,02:49:08,009,END 17
20000930,03:24:11,010,RING dealer <no Caller ID> -> <no Called ID>
20000930,03:24:31,010,MENU menuZipConfirm 1
20000930,03:24:48,010,PROMPT T/O Dummy 0
20000930,03:25:03,010,PROMPT T/O Dummy 0
20000930,03:25:16,010,PROMPT T/O Dummy 0
20000930,03:25:21,010,MENU newZipMenu 1
20000930,03:25:34,010,PROMPT T/O Dummy 0
20000930,03:25:47,010,PROMPT T/O Dummy 0
20000930,03:25:59,010,HANG
20000930,03:25:59,010,END 108
20000930,06:58:09,011,RING dealer <no Caller ID> -> <no Called ID>
20000930,06:58:37,011,MENU menuZipConfirm 1
20000930,06:58:55,011,PROMPT T/O Dummy 0
20000930,06:59:06,011,PROMPT T/O Dummy 0
20000930,06:59:18,011,PROMPT T/O Dummy 0
20000930,06:59:27,011,MENU newZipMenu 1
20000930,06:59:39,011,PROMPT T/O Dummy 0
20000930,06:59:52,011,PROMPT T/O Dummy 0
20000930,07:00:05,011,PROMPT T/O Dummy 0
20000930,07:00:09,011,MENU newZipMenu 1
20000930,07:00:20,011,PROMPT T/O Dummy 0
20000930,07:00:35,011,HANG
20000930,07:00:35,011,END 146
20000930,07:30:17,012,RING dealer <no Caller ID> -> <no Called ID>
20000930,07:30:49,012,PROMPT T/O afnInputZip 501
20000930,07:30:57,012,HANG
20000930,07:30:58,012,END 41
20000930,07:52:29,013,RING dealer <no Caller ID> -> <no Called ID>
20000930,07:52:56,013,MENU menuZipConfirm 1
20000930,07:53:08,013,HANG
20000930,07:53:08,013,END 39
20000930,07:57:35,014,RING dealer <no Caller ID> -> <no Called ID>
20000930,07:58:02,014,MENU menuZipConfirm 1
20000930,07:58:18,014,PROMPT T/O Dummy 0
20000930,07:58:32,014,PROMPT T/O Dummy 0
20000930,07:58:46,014,PROMPT T/O Dummy 0
20000930,07:59:02,014,MENU newZipMenu 9
20000930,07:59:05,014,END 90
20000930,08:01:33,001,RING dealer <no Caller ID> -> <no Called ID>
I really need some help.
thank you.
-
Hi,
Thank you for your response. I tried the code but it was erroring out on (Public fs As New Scripting.FileSystemObject)
Where am I supposed to declare this.
Also, how would I be able to figure out which element is which in the text file. Because the calculations that I will be performing will be things like Longest call, avg_call length, line #. So, I will have to be able to get the first line and figure out which element are what and then search through the entire file and then do my manipulations.
Thank you.
