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;Jenifer;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]
