Wrox Programmer Forums
|
ASP CDO As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP CDO section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 21st, 2004, 04:11 PM
Authorized User
 
Join Date: Dec 2003
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default Parse Flat File Data - Asp


Hello, and thanks in advance for considering this post...

What I have is a directory, called 'things', that has 200 files in it.

Each file contains tab separated data...

What I want to do is have a script that parses each file in the 'things' directory, and have the script add a record in a database that has data in two fields"

Field one: the piece of data in the file
Field two: the name of the file currently being parsed

Does this make sense? I can get data into databases okay, but loading, parsing, and getting the filename of each file in the 'things' directory is the piece I'm missing - Though I'm likely missing more :)

Thanks!!!

Darin



 
Old May 22nd, 2004, 08:17 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

How are you trying to get the data and attributes from the files? Are you using the Scripting.FileSystemObject class?

Brian
 
Old May 22nd, 2004, 12:27 PM
Authorized User
 
Join Date: Dec 2003
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default


I wasn't sure where this question fit in, but a good answer seems to be forming at the ASP Database forum:
http://p2p.wrox.com/topic.asp?TOPIC_ID=13858

Thanks for the help!!

Darin







Similar Threads
Thread Thread Starter Forum Replies Last Post
How to export Data from MySql to flat file. SkyMouse XML 2 August 19th, 2008 03:04 PM
Export Mysql data to Flat file using .Net 2.0 SkyMouse .NET Framework 2.0 0 August 18th, 2008 11:36 PM
How to Parse - Parsing Flat File Data - Asp darinsee Classic ASP Databases 5 May 24th, 2004 04:11 PM
Parse - Parsing Flat File Data - Asp darinsee Classic ASP Basics 1 May 22nd, 2004 08:39 AM
Parse - Parsing Flat File Data - Asp darinsee Classic ASP Components 1 May 22nd, 2004 08:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.