Sign in to follow this  
Followers 0
cypher175

_FileReadToArray + 2D Array..?

4 posts in this topic

How can I read a .txt file into a 2D Array that's formatted like this..??

The spaces are TABS.

ABC 123 DEF 456 GHI
ABC 123 DEF 456 GHI
ABC 123 DEF 456 GHI
ABC 123 DEF 456 GHI
ABC 123 DEF 456 GHI

Share this post


Link to post
Share on other sites



cypher175,

- Read the file into an initial array using _FileReadToArray

- Create a second array with the right number of dimensions

- Split each element of the first array (i.e. each line) with StringSplit using @TAB as the delimiter

- Transfer the elements of the StringSplit array into the correct places in the second

Job done. ;)

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

cypher175,

BugFix wrote a couple functions pertaining to File Read/Write with 2D, his original post can be found #394415

Other than that, the only way I could suggesting is looping FileReadLine() than splitting and adding to the array

Example:

#include <File.au3>
#include <Array.au3>
Local $myFile="MyFile.txt"
$file=FileOpen($myFile,1)
$fileLines=_FileCountLines($myFile)
Local $myArray[$fileLines][5]
For $a=1 To $fileLines
    $line=StringSplit(FileReadLine($myFile,$a),@TAB)
    $myArray[0] = $line[1]
    $myArray[1] = $line[2]
    $myArray[2] = $line[3]
    $myArray[3] = $line[4]
    $myArray[4] = $line[5]
Next

FileClose($file)

_ArrayDisplay($myArray,"My Array")

I did not test the script, but in theory it should work. It will probably be slow if you are working with very large files.

Edit: Melba23's suggestion would more than likely be faster than the example I have provided.

Edited by Realm

My Contributions: Unix Timestamp: Calculate Unix time, or seconds since Epoch, accounting for your local timezone and daylight savings time. RegEdit Jumper: A Small & Simple interface based on Yashied's Reg Jumper Function, for searching Hives in your registry.  

Share this post


Link to post
Share on other sites

If every row has the same number of elements but you don't know how many elements each row has then this should work:

#include <file.au3>
#include <array.au3>
Global $aInFile
_FileReadToArray("C:\temp\test.txt", $aInFile)
$aDimension = StringSplit($aInFile[1], @TAB)
Global $aOutArray[$aInFile[0] + 1][$aDimension[0]]
For $iIndex1 = 1 To $aInFile[0]
    $aRecord = StringSplit($aInFile[$iIndex1], @TAB)
    For $iIndex2 = 0 To $aRecord[0]-1
        $aOutArray[$iIndex1][$iIndex2] = $aRecord[$iIndex2+1]
    Next
Next
$aOutArray[0][0] = $aInFile[0]
$aOutArray[0][1] = $aDimension[0]

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0