Hi Atrix, Yes, it's possible, and there is more than one way to do it - but your text files do need to have some structure to begin with.
Start by investigating the File/Read Action and the <@ARRAY> Metatag and the CDELIM and RDELIM attributes. Characters like a "tab", or a comma "," and a "end-of-line" sequence like "crlf" (carriage-return, line-feed) are typically what define your structure. Of course, you can also use "custom" characters you define use the CDELIM RDELIM attributes too. The first big pit-fall is making sure the number of CDELIM (column-delimiter) charaters is the same for every row in your file - else you can't make a 2-deminsional Array in Witango. Another pit-fall is when a text "field" in a row contains one of your delimiter characters and throughs everything out of whack, so choose characters that are the least likely to showup on your content (a non-regular ASCII character can be specified with <@ASCII>). Also, I think some Text ODBC Drivers may compensate for irregularities in some files, but can slow things down for you. Another option is to write all your log files in XML format, then life gets more interesting with Witango DOM Variables :-) Hope this helps. Cheers...... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xml-extra.net 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- -----Original Message----- From: Atrix Wolfe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:15 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: text files as data sources? hello, I faintly remember hearing somewhere you can take a text file and make it a datasource somehow and interact with it? Im looking to do this with witango log files so that we dont have to go through it manualy looking for errors, or other information. It seems strange that something would be able to look at a txt file and find a structure to it and break the data into columns and such but who knows! Am i nuts or is this possible? Thanks!! Atrix ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
