Manipulating Text File Database 1

[pkgraham]

I am currently working on a personal project that requires the use of a text database. I do not have access to any database system on the server so I will just be manipulating a text file. This may be a very broad question but I need to know how to manipulate a text database with columns delimited by commas or pipes.
I need to be able to pull individual records and display them in their entirety, and I also need to be able to do index lists only using 2 or 3 of the columns. Basically, I need to be able to do with a text file what I can do with any database.

I would appreciate any help.

Paul

 

[brianjay]

did you get an answer to your question (Aug. 2000)about uploading delimitted text files? I have a similar need now and I'm stuck at loading into my database file?
Brian

 

[ChiefJoseph]

CF dosen't seem to be designed to do this easily. Frankley, the EASIEST way to do this is with Perl(Hail the camel)

Theres probably hundreds of ways of accumplishing this task but what i would do is maybe

<CFFILE ACTION=&quot;APPEND&quot;
FILE=&quot;txtFile&quot;
OUTPUT=&quot;23|CF is good&quot;>

Then when reading the file make a loop that assigns the values into arrays(or whatever you want to do)