Querying a text file with no column names

[dinoviapangea]

How can I query a text file with no column names, for example:

Fred|Flintstone|Bedrock|
Betty|Rubble|Bedrock|
Barney|Rubble|Bedrock|
Spongebob|Squarpants|Bikini Bottom|

I can do the query with column headers, for example:

fname|lname|location|
Fred|Flintstone|Bedrock|
Betty|Rubble|Bedrock|
Barney|Rubble|Bedrock|
Spongebob|Squarpants|Bikini Bottom|

Any Ideas?

Thanks.

 

[Sarky78]

You could use CFHTTP to do it and get it to return the data as a query, then you just loop over the query like normal.

Like this:

<cfhttp url=&quot;

http://127.0.0.1/bnh/your_text_file.txt&quot;

method=&quot;get&quot;
delimiter=&quot;|&quot;
textqualifier=&quot;&quot;&quot;&quot;
Name=&quot;getData&quot;
columns=&quot;a,b,c&quot;
timeout=&quot;10&quot;
firstrowasheaders=&quot;no&quot;>

<table border=0 cellpadding=5 cellspacing=0>
<TR>
<TD>Column A</TD>
<TD>Column B</TD>
<TD>Column C</TD>
</TR>
<cfoutput query=&quot;getData&quot;>
<TR>
<TD>#getData.a#</TD>
<TD>#getData.b#</TD>
<TD>#getData.c#</TD>
</TR>
</cfoutput>
</table>

Hope this helps!

Tony