Help with Structure in array

<cfset myArray = listtoarray(MyFile,"#chr(13)##chr(10)#")>

<cfset myStruct = structNew()>

<cfloop from="1" to="#arrayLen(myArray)#" index="idx">
    <cfset currentRow = 'row' & idx>
    <cfset position = 1>
    <cfloop list = "#myArray[idx]#" delimiters=" " index="listElement">
        <cfset myStruct[currentRow][position] = listElement>
        <cfset position = position+1>
    </cfloop>
</cfloop>

<cfdump var="#myStruct#">

I find nested lists easier to deal with than 2D arrays.  To make it even easier, if you could give column headings to your text file, you can use cfhttp to create a query.

Well the basis for doing what you want is to loop over each record that builds the array and create a structure out of it.

How you do that is going to very somewhat depending on if you want to do this directly from the file so that in one larger fill reading step, you end up with and array of structures.  Or if you want to do it after you have read the file and created the array like you have already done, this would.

The latter is a bit simplier to show, but takes a tiny bit longer to process since you are effectivily looping over all the data twice.

<cfset myArray2 = arrayNew(1).
<cfloop array="#myArray#" index="i">
  <cfset arrayAppend(myArray2, structNew())>
  <cfset myArray2["key1"] = somePartOf(myArray)>
  <cfset myArray2["key2"] = somePartOf(myArray)>
  <cfset myArray2["key3"] = somePartOf(myArray)>
</cfloop>