> -----Original Message----- > From: Dana Tierney [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 29, 2007 3:03 PM > To: CF-Community > Subject: Re: need a suggestion > > ok ;) I can see I am not going to get a serious answer to the question > so let me rephrase it. I am thinking unix scripting + regular > expressions. Anyone have a better idea?
Not really - although there's a chance that SQL DTS could do this (I _think_ there's a method for data transformation from text files where you can specify a masking structure). SQL Server 2005 allows for Stored Procedures to be written in many languages (including, if I remember correctly, JavaScript). You might be more comfortable doing your RegEx scripting there. If you can do everything in SQL Server you can then wrap everything up into a re-runnable, SQL-schedule-able DTS package. (DTS in SQL Server is really powerful but often ignored.) You can also use SQL Scripts from the command-line using the OSQL utility. You can use Windows Scripting Host to do a lot of the work - fetch the data from the remote server, pull it, Reg-EX into a workable input file, etc. I did a lot of this recently to pull log files from a AIX server and import them into a SQL Server. Can you modify/adjust the HTML file? Getting a tab/comma separated list instead would make your task significantly easier. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233499 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
