Jerry Mallett wrote: > 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?
Not strictly necessary if you have a guarantee that a comma may not otherwise appear within a field. > Shouldn't the format > be one line per record and not spread over numerous lines? Also not particularly necessary; Internet text file formats are historically line-terminator "neutral". If you're using code that expects lines, you'll probably have to parse out the embedded breaks and reformat first. > 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.) You can try the TStrings CommaText property, which unfortunately has some non-standard behaviors. For some more sophisticated handling, I'd suggest you have a look at the delimited text classes in TurboPower's SysTools; which are (of course) now open source and available on SourceForge. > 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. Could be, I have no experience with that. HTH Stephen Posey [EMAIL PROTECTED] This message and its attachments are for the sole use of the intended recipient(s) and may contain confidential, proprietary and privileged information. Any unauthorized review, copying, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to the address listed in the From: field and destroy all copies of the original message and its attachments. _______________________________________________ Delphi mailing list -> [email protected] http://www.elists.org/mailman/listinfo/delphi
