well yeah once I see it I can do whatever I need to with it, including getting it to CSV. If I understand your question. Snippet coming up.
>> -----Original Message----- > >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:233501 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
