Jump to content

String Table To Array?


Recommended Posts

I have a string that look like this:


WIFI    13.8    26.59
BCRX    9.6    13.34
GTES    8.5    11.15
DFRG    5.9    33.02
GIL    5.5    12.08

How can I simply build an Array with it?
 

Link to comment
Share on other sites

  • Moderators

toto22,

This seems to work:

#include <StringConstants.au3>
#include <Array.au3>

$sInput = "WIFI    13.8    26.59" & @CRLF & _
    "BCRX    9.6    13.34" & @CRLF & _
    "GTES    8.5    11.15" & @CRLF & _
    "DFRG    5.9    33.02" & @CRLF & _
    "GIL    5.5    12.08"

; Replace all spaces by "|"
$sInput = StringRegExpReplace($sInput, "\h+", "|")

ConsoleWrite($sInput & @CRLF)

; Split string on @CRLF
$aSplit_1 = StringSplit($sInput, @CRLF, $STR_ENTIRESPLIT)
; Split first line on "|"
$aSplit_2 = StringSplit($aSplit_1[1], "|")

; Create suitably sized array
Global $aArray[$aSplit_1[0]][$aSplit_2[0]]

; For each line
For $i = 1 To $aSplit_1[0]
    ; Split on "|"
    $aSplit_2 = StringSplit($aSplit_1[$i], "|")
    ; Fill array
    For $j = 1 To $aSplit_2[0]
        $aArray[$i - 1][$j - 1] = $aSplit_2[$j]
    Next
Next

; And here is the result
_ArrayDisplay($aArray, "", Default, 8)

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see 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

 

Link to comment
Share on other sites

  • Moderators

toto22,

My pleasure as always.

M23

Public_Domain.png.2d871819fcb9957cf44f4514551a2935.png Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind

Open spoiler to see 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

 

Link to comment
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
 Share

×
×
  • Create New...