Just had confirmation on this file format. 30 Fields in total and all are output regardless of content. I had thought that each record started with the date and time of call but that info appears twice in the record so I've seperated the records for clarity.
27/07/2006 12:15,Catherine Bradley,Modules.CallServer 00 -07-d9-00-1c-6b.PRI,Catherine Bradley,2180,,,07813922167,63390,26830,,,1,,, Catherine Bradley,d40d0300-e4a6-c814-927e-0007d9001fc7,0,,10,30890,20970, 27/07/2006 11:15:46.513,,1,Catherine Bradley,,,0, 27/07/2006 12:16,Cheryl Rainey,Modules.CallServer 00-07-d9-00-1c-6b.PRI,Cheryl R ainey,2022,,,00353749156837,36620,14250,,,1,,,Cheryl Rainey,d4200a00-4ca5-c814-b 868-0007d90019a1,0,,10,20250,16170, 27/07/2006 11:16:06.274,,1,Cheryl Rainey,,,0, 27/07/2006 12:16,McCambridge Duffy Customer Care one,,,07775911808,Theresa Gilli spie,McCambridge Duffy Customer Care one,8001,115180,112730,,,1,Modules.CallServ er 00-07-d9-00-1c-6b.PRI,2000,McCambridge Duffy Customer Care one,47f50700-04a0- c814-b011-0007d9001c6b,0,6c350d00-6aa1-c814-8770-0007d9001aa2,110,2340,2240, 27/07/2006 11:16:07.735,,1,McCambridge Duffy Customer Care one,,,0, 27/07/2006 12:16,Theresa Gillispie,,Theresa Gillispie,2000,Danielle mc conway,Da nielle mc conway,2168,42580,24620,,,1,,2168,Theresa Gillispie,6c350d00-6aa1-c814 -8770-0007d9001aa2,1,47f50700-04a0-c814-b011-0007d9001c6b,0,3220,3190,27/07/2006 11:16:07.736,,1,Theresa Gillispie,,,0,, It has been suggested that this is a CSV file but my limited knowledge tells me it's not a true CSV. Shouldn't text fields be enclosed in quote "" marks? Shouldn't the format be one line per record and not spread over numerous lines? . What is the best way of reading in this file one record at a time.( Would really like to know how to properly read in and manipulate text files. See plenty of tutorials on more advance subjects but never any to deal with the common text file.) Also, I was wondering, could I use a Telnet component in my Delphi App. to directly access the 4001 port and pull the data directly into my database. This option would be preferred. For the record, Using Delphi v5, Indy 9, and Topaz Database Components. _______________________________________________ Delphi mailing list -> [email protected] http://www.elists.org/mailman/listinfo/delphi
