RE: manipulating a text file...

2002-04-19 Thread Houk, Gary
day, April 19, 2002 11:06 AM To: CF-Talk Subject: RE: manipulating a text file... Mind sharing witht he rest of us how you did it?? was it with the code below? T. -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 9:57 AM To: CF-Talk Subject: RE: ma

RE: manipulating a text file...

2002-04-19 Thread Tammy Hong
Mind sharing witht he rest of us how you did it?? was it with the code below? T. -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 9:57 AM To: CF-Talk Subject: RE: manipulating a text file... Thanks for your help everyone!!! I got it working

RE: manipulating a text file...

2002-04-19 Thread Houk, Gary
Thanks for your help everyone!!! I got it working. The boss will be happy now ;-) - Gary -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:49 AM To: CF-Talk Subject: RE: manipulating a text file... Give it a try. You know you want to

RE: manipulating a text file...

2002-04-19 Thread Jerry Johnson
very simple fuctions for working with files. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:22 AM To: CF-Talk Subject: RE: manipulating a text file... Yeah,

RE: manipulating a text file...

2002-04-19 Thread Alex
Perl. Read in the file. Use seek() and a regular expression. Then output the result. On Fri, 19 Apr 2002, Mark A. Kruger - CFG wrote: > ouch... > > well, if the file is structured you might try the text based ODBC driver. > Personally, I think it would be easier to host the data in a database

RE: manipulating a text file...

2002-04-19 Thread Houk, Gary
There are 3 .txt files I need to do alter, all of which are under 5 mb... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:33 AM To: CF-Talk Subject: RE: manipulating a text file... you can use cffile, the thing is how big is the

Re: manipulating a text file...

2002-04-19 Thread Justin Scott
. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 9:59 AM > To: CF-Talk > Subject: RE: manipulating a text file... > > > ouch... > > well, if the file is structured you might try the text based ODBC > driver. > Personally, I think it would be ea

RE: manipulating a text file...

2002-04-19 Thread Houk, Gary
no, it is not delimited... -Original Message- From: David Schmidt [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:32 AM To: CF-Talk Subject: RE: manipulating a text file... Have you tried opening it in Excel? Is it delimited? Dave Schmidt > -Original Mess

RE: manipulating a text file...

2002-04-19 Thread Tony_Petruzzi
ruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:22 AM To: CF-Talk Subject: RE: manipulating a text file... Yeah, if I had more time, I could look into that, but of course

RE: manipulating a text file...

2002-04-19 Thread David Schmidt
Have you tried opening it in Excel? Is it delimited? Dave Schmidt > -Original Message- > From: Houk, Gary [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 7:22 AM > To: CF-Talk > Subject: RE: manipulating a text file... > > > Yeah, if I had more time

RE: manipulating a text file...

2002-04-19 Thread Tim Claremont
Gary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 10:22 AM To: CF-Talk Subject: RE: manipulating a text file... Yeah, if I had more time, I could look into that, but of course this is due by end of day. Is there basically no way that this can be done with cffile? - gary -Ori

RE: manipulating a text file...

2002-04-19 Thread Houk, Gary
Subject: RE: manipulating a text file... ouch... well, if the file is structured you might try the text based ODBC driver. Personally, I think it would be easier to host the data in a database and export it OUT into a file when it's needed in a file format. Mark -Original Message- From:

RE: manipulating a text file...

2002-04-19 Thread Mark A. Kruger - CFG
ouch... well, if the file is structured you might try the text based ODBC driver. Personally, I think it would be easier to host the data in a database and export it OUT into a file when it's needed in a file format. Mark -Original Message- From: Houk, Gary [mailto:[EMAIL PROTECTED]] Se

RE: Manipulating a text file ... how to convert a type?

2001-12-04 Thread Mike Kear
IL PROTECTED]] > Sent: Tuesday, December 04, 2001 9:07 PM > To: CF-Talk > Subject: RE: Manipulating a text file ... how to convert a type? > > > Mike - you can setup the text driver to auto-cast the datatypes > > go to your dsn's properties ODBC Text Setup >

RE: Manipulating a text file ... how to convert a type?

2001-12-04 Thread Rich Wild
Mike - you can setup the text driver to auto-cast the datatypes go to your dsn's properties ODBC Text Setup >> Options >> Define Format >From there you can setup the datatype of each of the csv's columns. > -Original Message- > From: Mike Kear [mailto:[EMAIL PROTECTED]] > Sent: 04 Decem