I get a large ASCII text file every month, and I want to read it into a 2D
array so I can manipulate it then write it out to a HTML file in a series of
tables. But I'm stumped with the second dimension of the array. I can
read it into one dimensional table like this:
<CFSET filearray = ArrayNew(1)>
<CFLOOP List="#file_content#" Index="rc" Delimiters="#Chr(10)#">
<CFSET rc = ArrayAppend(filearray, rc)>
</CFLOOP>
How do I make it into the two dimensional array instead? Here's a sample
of the text I get. I want the elements in the second dimension to break on
the pipe character.
[sample text]
UBS Asset Management (Australia) Ltd|SBC0813AU|UBS Australian
Bond|339.30|7.77|5.31|8.02|0.42|~~~~~|8/55||
Colonial First State Invest Aust Ltd|FSF0027AU|Col First State Wsale
AustBond|24.42|7.50|5.16|7.88|0.46|~~~~|7/55||
IOOF Funds Management|IOF0012AU|IOOF Flex Tr
FI|6.23|6.91|5.14|7.47|1.12|~~~~~|5/55||
Commonwealth Financial Services|COM0011AU|C'Wealth Bond
Fund|146.70|6.68|4.91|6.46|1.11|Not Rated|0/55||
[end sample]
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
