Jump to content
Sign in to follow this  
marko001

Editbox values to Array?

Recommended Posts

marko001

Hi all guys,

I'm trying to find a solution for the following:

I have an Editbox

$CH_Edit = GUICtrlCreateEdit("", 71, 40, 81, 353, BitOR($WS_VSCROLL,$ES_WANTRETURN))
$CH_Close = GUICtrlCreateButton("Save&Close", 70, 408, 75, 25)

 

and I would like to pass to an array all the datas inside, row by row.

i.e. if I have in the editbox

John-Holder

Frank-MCGregor

Alex-Dentis

I would like to have, once Button has been clicked,

dm $names[100][2] ; fixed or it would be better dinamic based on the row of the editbox

 

and

$names[0][0]=John
$names[0][1]=Holder
$names[1][0]=Frank
$names[1][1]=MCGregor
$names[2][0]=Alex
$names[2][1]=Dentis

 

Can you please help me to solve this?

Thanks in advance,

Marco

Share this post


Link to post
Share on other sites
UEZ

Try something like this here:

#include <Array.au3>

$sText = "John-Holder" & @CRLF & _
         "Frank-MCGregor" & @CRLF & _
         "Alex-Dentis"

$a = StringRegExp($sText, "(.+)\S*", 3)

Global $aSplitted[UBound($a)][2]
For $i = 0 to UBound($a) - 1
    $aTmp = StringRegExp($a[$i], "(\w+)", 3)
    $aSplitted[$i][0] = $aTmp[0]
    $aSplitted[$i][1] = $aTmp[1]
Next

_ArrayDisplay($aSplitted)

No error checks added!

Br,

UEZ

Edited by UEZ

Please don't send me any personal message and ask for support! I will not reply!

Selection of finest graphical examples at Codepen.io

The own fart smells best!
Her 'sikim hıyar' diyene bir avuç tuz alıp koşma!
¯\_(ツ)_/¯  ٩(●̮̮̃•̃)۶ ٩(-̮̮̃-̃)۶ૐ

Share this post


Link to post
Share on other sites
marko001

Hi UEZ and thanks, it works perfectly.

Just one thing: I'm usual to store all datas in a settings.ini file

IniWrite($_settings, "Datas", "Full Names", GUICtrlRead($ch_edit))

In this way it stores the datas in this way:

[Datas]

[...]
Full Names=John-Holder
Frank-MCGregor
Alex-Dentis

and this is an error since when I'll iniread(..) it will get just read into editbox the first name after the key.

Shall I save the editbox content to a file and call it at _loadsettings()?

Thanks,

Marco

Share this post


Link to post
Share on other sites
mikell

Do you want the ini to look like this

[Full Names]
1=John-Holder
2=Frank-MCGregor
3=Alex-Dentis

or this

[Data]
Full Names=John-Holder,Frank-MCGregor,Alex-Dentis

or else ?

Share this post


Link to post
Share on other sites
marko001

Honestly it's important for me to iniread() and iniwrite() them so I can get them back.

I will, when needed, store the values to the array[$x][$y].

Second solution seems more "space"-efficient since I have other keys in the .ini

It's important I can retrieve them and store in the editbox.

Thanks a lot, mate.

Marco

Share this post


Link to post
Share on other sites
mikell

Here it is, very raw

But maybe it's not the best way if you have a huge number of names to store  :)

#include <Array.au3>

$_settings = "settings.ini"

$sText = "John-Holder" & @CRLF & _
         "Frank-MCGregor" & @CRLF & _
         "Alex-Dentis"
$names = StringReplace($sText, @crlf, ",")
IniWrite($_settings, "Data", "Full Names", $names)

$a = StringRegExp($sText, "(.+)\S*", 3)

Global $aSplitted[UBound($a)][2]
For $i = 0 to UBound($a) - 1
    $aTmp = StringRegExp($a[$i], "(\w+)", 3)
    $aSplitted[$i][0] = $aTmp[0]
    $aSplitted[$i][1] = $aTmp[1]
Next
_ArrayDisplay($aSplitted)

$get = IniRead($_settings, "Data", "Full Names", "")
$names2 = StringReplace($get, ",", @crlf)
Msgbox(0,"", $names2)

Edit

typo...

Edited by mikell

Share this post


Link to post
Share on other sites
marko001

Great, yes I used it in the past and honestly I forgot it.

Thanks again dude,

Marco

Share this post


Link to post
Share on other sites
marko001

[sOLVED!]

Err... I found that if I use an editbox to store datas

$CH_Edit = GUICtrlCreateEdit("", 71, 56, 81, 313, BitOR($WS_VSCROLL,$ES_WANTRETURN))
GUICtrlSetData(-1, "")

It doesn't recognize the @crlf so using stringreplace() it doesn't work.

Any suggestion?

Thanks,

M.

Edited by marko001

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  

  • Similar Content

    • TrashBoat
      By TrashBoat
      So Im trying to make a simple 2d game and make some sort of collision detection so why not to make a 2 dimensional array but i have no clue how  to write it in multiple lines
      Global $map[5,5] = [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0] something like this but it doesn't work
    • Zein
      By Zein
      #include "..\Include\Array.au3" #include "..\Include\File.au3" #include "..\Include\AutoItConstants.au3" Local $aRetArray Local $sFilePath = "n.csv" _FileReadToArray($sFilePath, $aRetArray, ",") ; _FileReadToArray($sFilePath, $aRetArray, $FRTA_COUNT, ",") _ArrayDisplay($aRetArray, "Original", Default, 8) The above code shows two versions of _FileReadToArray and both don't work as expected.
      The first one doesn't use the comma as a delimiter. (so I get a single column array)  I tried adding "Default" between $aRetArray and "," then it told me it had an incorrect number of parameters. 

      I looked again at the documentation:
       
      #include <File.au3> _FileReadToArray ( $sFilePath, ByRef $vReturn [, $iFlags = $FRTA_COUNT [, $sDelimiter = ""]] )
      And I with or without the flags params I should be getting a 2D array due to my file being a csv. 
      I then tried a regular flag, $FRTA_COUNT, and it tells me that I'm using a variable $FRTA_COUNT while it's not declared. Tried putting in 1 instead and it told me again, incorrect number of params. 

       
    • ternal
      By ternal
      Hi,
      Recently I have had the need to do a sort and then do a second sort while the item of the first sort stays the same ( double sorting , first on column x then while column x is the same sort column y).
      I did not put much efffort into error checking but so far I did not need it.
      For my applications so far it works perfectly however if someone is willing I want to test this extensivly.
      If anyone has big lists of random stuff to sort could you try this out please?
      #include <Array.au3> ; #FUNCTION# ==================================================================================================================== ; Name ..........: _ArraySort_Double ; Description ...: ; Syntax ........: _ArraySort_Double (Byref $array[, $first_index = Default[, $second_index = Default[, $ascending = Default]]]) ; Parameters ....: $array - 2d array to sort. ; $first_index - [optional] first column to sort. Default is 0. ; $second_index - [optional] second column to sort. Default is 1. ; $ascending - [optional] ascending/descending. Default is 1. ; Return values .: 1 if no errors occured , -1 if errors occured ; Author ........: Ternal ; Remarks .......: Needs excessive testing. ; Related .......: _arraysort() ; =============================================================================================================================== Func _ArraySort_Double (byref $array, $first_index = Default, $second_index = Default, $ascending = Default) Local $temp_value Local $counter = 1 If UBound($array, $UBOUND_DIMENSIONS) <> 2 Then MsgBox(0, "error", "error") return -1 EndIf If $first_index = Default Then $first_index = 0 If $second_index = Default Then $second_index = 1 If $ascending = Default Then $ascending = 1 _ArraySort($array, $ascending, 0, 0, $first_index); you can alter settings of primary sort here If @error Then MsgBox(0, "error", @error) return -1 EndIf $temp_value = $array[0][$first_index] For $x = 1 to UBound($array, 1) - 1 If Mod( $x, 10000) = 0 Then ConsoleWrite("at " & $x & " of a total : " & UBound($array, 1) & @CRLF) If $array[$x][$first_index] = $temp_value Then $counter+= 1 If $x = UBound($array, 1) - 1 Then; do last line here(if last line is not a new item) _ArraySort($array, $ascending, $x - $counter, $x, $second_index);you can alter settings of secondary sort here(don't forget to place line 34 the exact same) If @error Then MsgBox(0, "error", @error) return -1 EndIf EndIf Else If $counter > 0 Then ;at least 2 of the same _ArraySort($array, $ascending, $x - $counter, $x - 1, $second_index);you can alter settings of secondary sort here(don't forget to place line 29 the exact same) If @error Then MsgBox(0, "error", @error) return -1 EndIf $counter = 1 EndIf EndIf $temp_value = $array[$x][$first_index] Next Return 1 EndFunc Kind regards, Ternal
    • TrashBoat
      By TrashBoat
      So I've made this script that detects how long i have held down my left mouse button for and stores the information in an array and then sorts its using _ArraySort but the output is half sorted half broken.
      Here's my script:
      HotKeySet("{F1}","_exit") #include <Misc.au3> #include <Timers.au3> #include <Array.au3> Local $dll = DllOpen("user32.dll") $on = False Global $array[0] While(1) If _IsPressed(01,$dll) Then $timer = _Timer_Init() While _IsPressed(01,$dll) Sleep(1) WEnd $time = _Timer_Diff($timer) _ArrayAdd($array,"Time: " & Floor($time) & " ms") ;~ ConsoleWrite("Time: " & Floor($time) & " ms" & @CRLF) EndIf Sleep(50) WEnd Func _exit() _ArraySort($array) _ArrayDisplay($array) Exit EndFunc And the output:

      See how its not sorted?  What is the problem here?
    • MrCheese
      By MrCheese
      Hi guys,
      See attached for an array example.
      to simplify what i want to achieve,  I want to split this array into 9 different csv files.
      the first file would contain the list of "key" and the corresponding "ID1", the second would have "key" and the "ID2", the third would have "key" and "ID3"
      However, I want to remove all the rows that don't have an ID recorded in the respective ID2, ID3 4...5...6 etc, so the file only contains row items with a key and the ID.
      Would be the best way to loop through the rows and delete the row if the array field is blank - would I then need to repeat that row ID to check that the row that its replaced is also empty (ie the one after the one I just deleted)? I see this getting messy.
      or _arraySort, and delete everything below the last filled row? <-- this might be best?
      Or should I use the excel UDF, apply a filter (not selecting the blanks), then create/export to the array->csv?
       
      Super keen to hear your thoughts.
      thanks!
       
       
       
       
      IDArray.csv
×