Import Text file then split or parse into 2 dimensional array

[polarisking]

Here's what I want to do
1. Import a large (220MB) pipe-delimited txt file very quickly (this works). Let's say the file has 280,000 rows. At this point I'll have a 1 dimensional array (strData) with 280,000 rows.
2. Now, I want to split each row using the "|" character into another array splitArr that's defined as splitArr(ubound(strData,188)
How Do I Do This?

Thank you in advance

Sub Sample()

    Dim MyData      As String
    Dim strData()   As String
    Dim splitArr    As Variant
    Dim ctr         As Long
    Dim arrRows     As Long
    Dim arrCols     As Long
    
    Open "FileLocation" For Binary As #1
    MyData = Space$(LOF(1))
    Get #1, , MyData
    Close #1
    
    strData() = Split(MyData, vbLf)
    
    ReDim ArrName(UBound(strData), 188)
    
'Everything's good up to here

'Can I use the SPLIT command to parse out each single line containing 188, separated by "|", values?
    
    Stop
    
End Sub

 

[Marc L]

Use Split VBA function to parse the array or better if the data are directly imported within a worksheet use TextToColumns feature …​

​

 

[polarisking]

I need to know how to implement the SPLIT function to load the second array.

 

[Marc L]

Use a loop to parse each array element like the post #4 of this thread :​

copy specific from a text file to excel sheet using vba

I am trying to extract certain data from a text file(Source) into an Excel spreadsheet I want copy the value from these two following line TestTime Avg: 74.9451 TestTime StdDev: 3.1523 Attached sample txt file and required output excel file Really appreciate your help!!!!

chandoo.org