(assuming there are LF and/or CR at then end of each line).
if no LF and/or CR looks like you could use the date to know when each new
line starts.
Grab the first 6 elements of each line(below they are consistent:
date;code;lib;value1;value2;value3).
Then every three elements after that until end of line will be Name;First
Name;Value.
using list functions to do this.
drop the file in front of #File.message#
scope using variables
hope this helps
-----Original Message-----
From: Nicolas CHALLEL
[mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:14 AM
To: CF-Talk
Subject: txt file which lines don't have the same length
Hi,
How can I make a request by using a txt file which lines don't have the same
length ?
This txt file is generated by a compiled program that make lines of this
type with ";" as delimeter.
example lines...
date;code;lib;value1;value2;value3;Name;First name;value;
13/01/2004
11:36;345;London;00000025;00000415;00000012;SMITH;Deborah;00000085;
13/01/2004
11:36;202;Paris;00000144;00000002;00000711;CLIFTON;Jack;00000055;COLLINS;Jen
ifer;00000033;
13/01/2004
11:36;711;TOKYO;00000125;00000075;00000102;PAUL;Sean;00000077;BOSTON;Mickael
;00000114;CHRIS;Helen;00000072;
On line #2 you read Clifton and Collins attached to {13/01/2004
11:36;202;Paris;00000144;00000002;00000711;}
but on line#3 there are Paul,Boston and Chris attached to {13/01/2004
11:36;202;Paris;00000144;00000002;00000711;} and I can't duplicate my
columns' name
I just can have one Name column, one Surname column and one value Column and
yet, this txt files contains 2 or 3 or 4 persons for one record...
I've tried to use <CFFILE action="" and read somewhere that I should
use a loop function to place each element in an array while indicating row
number, but my server CF5.0 returns this error :
Error processing CFFILE<P> Error attempting to read 'C:\Documents and
Settings\myName\R54T01.txt.'
and I typed this code :
<cffile action="" file="C:\Documents and Settings\myName\R54T01.txt"
variable="Message">
<cfoutput>#file.message#</cfoutput>
the option box CFFILE is properly ticked in the CF administrator settings...
but I can't read anything and I need to create a requested table no matter
how many people by line
Can someone help me ?
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
