Jump to content
Sign in to follow this  
dreamzboy

Read String into Array and Swap

Recommended Posts

dreamzboy

Hi All,

Sorry for raising this noobie thread but I can't seem to find a function that can read a string and break it up into an Array. I hope it's easy to do. I can do this in C but Autoit is a little different. Here's an example of what I would like to do, have an input box (GuiCtrlCreateEdit) where user can paste the information into it and my program will swap the information to have the output below with a click of a button:

User Input:

134.567.890.123 Hostname1 #Some comment on the Hostname

094.123.344.333 Hostname2 #Another comment on the Hostname.

.

.

To be specific:

Array[0,0] = 134.567.890.123 Array[0,1] = Hostname 1

Array[1,0] = 094.123.344.333 Array[1,1] = Hostname 2

What I would like to see in the output:

Hostname1 134.567.890.123

Hostname2 094.123.344.333

.

.

.

One method that I was going to use is StringisSpace, but that function only detects spaces. If there are any characters within it, it does not work. How will I go about making this work? I know I'll have to use the "_Arrayswap" function within the library but will it work given that I have 2 dimensions array?

Thanks in advance guys! It's been awhile since I did any programming.

Edited by dreamzboy

Share this post


Link to post
Share on other sites
Mechaflash

tab delimited?


Spoiler

“Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”

 

Share this post


Link to post
Share on other sites
iamtheky

Dim $Aarray[2][2]

$Aarray[0][0] = "134.567.890.123"
$Aarray[0][1] = "Hostname 1"
$Aarray[1][0] = "094.123.344.333"
$Aarray[1][1] = "Hostname 2"


msgbox (0, '' , $Aarray[0][1] & @TAB & $Aarray[0][0] & @CRLF & $Aarray[1][1] & @TAB & $Aarray[1][0])


,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites
DicatoroftheUSA

Another skinned cat. It may be a faster script without messing with arrays.

$sSampleText="134.567.890.123 Hostname1 #Some comment on the Hostname"

$sSampleText=StringRegExpReplace($sSampleText , '(.*?)h+(.*?)h+(#.*)v?' , '$2 $1 $3' , 0)
MsgBox(0,"gar",$sSampleText)
Edited by DicatoroftheUSA

Share this post


Link to post
Share on other sites
dreamzboy

tab delimited?

It's sometime space and sometime tab.

Share this post


Link to post
Share on other sites
dreamzboy

Another skinned cat. It may be a faster script without messing with arrays.

$sSampleText="134.567.890.123 Hostname1 #Some comment on the Hostname"

$sSampleText=StringRegExpReplace($sSampleText , '(.*?)h+(.*?)h+(#.*)v?' , '$2 $1 $3' , 0)
MsgBox(0,"gar",$sSampleText)

This will not work because I'm going use GuiCtrlCreateEdit and have user input those information. It could ranges from 1 line to 100 lines. The program would need to read the user input and then convert it to the output suggested above.

Share this post


Link to post
Share on other sites
DicatoroftheUSA

Here is another example with multiple lines with some built in pattern detection. Notice the string after @crlf is relatively backwards.

$sSampleText="134.567.890.123 Hostname1 #Some comment on the Hostname"&@CRLF&"Hostname2 094.123.344.333 #Another comment on the Hostname."

$sSampleText=StringRegExpReplace($sSampleText , '([0-9]{1,3}[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3})h+(.*?)h+(#.*)v?' , '$2 $1 $3' )
$sSampleText=StringStripWS($sSampleText,4)
MsgBox(0,"gar",$sSampleText)
Edited by DicatoroftheUSA

Share this post


Link to post
Share on other sites
dreamzboy

Thanks for the useful tip. It's just unfortunate that your code is not flexible. Quite honestly, I'm looking for a function to detect a "space or tab" between the string, from there I'll know how to break it up into arrays to make the code easier to manage. I'll hate to do all this in a C console while Autoit has such a nice GUI to it.

Any additional help is much appreciated.

Share this post


Link to post
Share on other sites
Mechaflash

You can grill and season it...

#include <Array.au3>
Local $asInput[2], $asOutput[2][2]
$asInput[0] = "192.168.0.1" & @TAB & "hostname 1" & @TAB & "#some comment about hostname 1"
$asInput[1] = "192.168.0.2 hostname 2 #some comment about hostname 2"
For $string in $asInput
    _Output($asOutput, $string)
    If @error Then msgbox(64 + 262144, @ScriptName, "Failed to parse '" & $string & "'. Was not TAB or SPACE delimited.")
    _ArrayDisplay($asOutput) ; Check Output
Next

Func _Output(ByRef $asOutput, $sString)
    Static $x = 0 ; hehe... static-x
    $asSplit = StringSplit($sString, "#")
    If Not @error Then $sString = $asSplit[1]
    If StringInStr($sString, @TAB) Then
        $asSplit = 0
        $asSplit = StringSplit($sString, @TAB)
        $asOutput[$x][0] = $asSplit[2]
        $asOutput[$x][1] = $asSplit[1]
        $x+=1
        Return SetError(0,0,True)
    Else
        $iSpace = StringInStr($sString, " ")
        If Not @error Then
            $asOutput[$x][0] = StringRight($sString, StringLen($sString) - $iSpace)
            $asOutput[$x][1] = StringLeft($sString, $iSpace - 1)
            Return SetError(0,0,False)
        Else
            Return SetError(1,0,False)
        EndIf
    EndIf
    Return SetError(1,0,False)
EndFunc
  • Like 1

Spoiler

“Hello, ladies, look at your man, now back to me, now back at your man, now back to me. Sadly, he isn’t me, but if he stopped using ladies scented body wash and switched to Old Spice, he could smell like he’s me. Look down, back up, where are you? You’re on a boat with the man your man could smell like. What’s in your hand, back at me. I have it, it’s an oyster with two tickets to that thing you love. Look again, the tickets are now diamonds. Anything is possible when your man smells like Old Spice and not a lady. I’m on a horse.”

 

Share this post


Link to post
Share on other sites
dreamzboy

You can grill and season it...

#include <Array.au3>
Local $asInput[2], $asOutput[2][2]
$asInput[0] = "192.168.0.1" & @TAB & "hostname 1" & @TAB & "#some comment about hostname 1"
$asInput[1] = "192.168.0.2 hostname 2 #some comment about hostname 2"
For $string in $asInput
_Output($asOutput, $string)
If @error Then msgbox(64 + 262144, @ScriptName, "Failed to parse '" & $string & "'. Was not TAB or SPACE delimited.")
_ArrayDisplay($asOutput) ; Check Output
Next

Func _Output(ByRef $asOutput, $sString)
Static $x = 0 ; hehe... static-x
$asSplit = StringSplit($sString, "#")
If Not @error Then $sString = $asSplit[1]
If StringInStr($sString, @TAB) Then
$asSplit = 0
$asSplit = StringSplit($sString, @TAB)
$asOutput[$x][0] = $asSplit[2]
$asOutput[$x][1] = $asSplit[1]
$x+=1
Return SetError(0,0,True)
Else
$iSpace = StringInStr($sString, " ")
If Not @error Then
$asOutput[$x][0] = StringRight($sString, StringLen($sString) - $iSpace)
$asOutput[$x][1] = StringLeft($sString, $iSpace - 1)
Return SetError(0,0,False)
Else
Return SetError(1,0,False)
EndIf
EndIf
Return SetError(1,0,False)
EndFunc

This is good. Thanks a bunch!! Time to bring out the bbq sauce. ;)

Share this post


Link to post
Share on other sites
UEZ

Here another version:

#include <Array.au3>
$sIP = "134.567.890.123    Hostname1       #Some comment on the Hostname" & @CRLF & _
            "094.123.344.333       Hostname2       #Another comment on the Hostname" & @CRLF & _
            "123.222.111.10        Hostname3       #3rd entry"

$aResult = TransformInput($sIP)
If Not @error Then _ArrayDisplay($aResult)

Func TransformInput($sText)
    If Not IsString($sText) Then Return SetError(1, 0, 0)
    If $sText = "" Then Return SetError(2, 0, 0)
    Local $aSplit = StringRegExp($sText, "(?m)s*(d{1,3}.d{1,3}.d{1,3}.d{1,3})s*(w+)s*", 3)
    If @error Then Return SetError(3, 0, 0)
    Local Const $iUB = UBound($aSplit)
    Local $a2D[Floor($iUB / 2)][2], $i, $j = 0
    While $i < $iUB
        Switch BitAND($i, 1)
            Case 1
                $a2D[$j][0] = $aSplit[$i]
                $j += 1
            Case 0
                $a2D[$j][1] = $aSplit[$i]
        EndSwitch
    $i += 1
    WEnd
    Return $a2D
EndFunc

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

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

    • lattey
      By lattey
      hi,
      i have checkboxes and each checkbox that checked, i put in array. 
      now, im stuck on how to loop the checked array and store in in one variable. what i can do now, is only write the result into a text file. 
      below is the code:
      #include <GUIConstantsEx.au3> ;~ #include <MsgBoxConstants.au3> #include <ButtonConstants.au3> #include <Array.au3> Global $Count = 3 Global $CheckBoxP[$Count] Global $step[$Count] global $array1[1] Global $ExitResult $hGUI = GUICreate("Summary Steps", 500, 400) GUISetFont(12, 400, "Tahoma") GUICtrlCreateLabel( "Please Select the Summary Steps for Script Check", 70, 20) GUISetFont(10, 400, "Tahoma") Global $array_Pstep[3] = ["fix2","fix1","fix3"] global $step[3] = ["2","3","4"] $Spacing = 50 For $i = 0 To UBound($array_Pstep) - 1 $CheckBoxP[$i] = GUICtrlCreateCheckbox($array_Pstep[$i], 80, $Spacing + (20 * $i), 65, 17) Next $submit = GUICtrlCreateButton("Submit",180, 280, 80, 30) $exit = GUICtrlCreateButton("Exit",180, 320, 80, 30) GUISetState() While 1 $Msg = GUIGetMsg() Select case $Msg=$submit For $i = 0 To $Count - 1 If GUICtrlRead($CheckBoxP[$i]) = $GUI_CHECKED Then _ArrayAdd($array1, $step[$i]) EndIf Next Global $logfilerray = @WorkingDir & "\checkedlist.txt" FileDelete ($logfilerray) Global $readlogfile = FileOpen($logfilerray,1) for $a = 1 to UBound($array1) - 1 ;~ $var=$array1[$a] FileWriteLine($readlogfile,$array1[$a]) Next FileClose($readlogfile) Exit case $Msg=$exit $ExitResult = MsgBox(1,"Summary Step", "Continue to Exit ?") if $ExitResult = 1 Then ;ok Exit EndIf Exit EndSelect WEnd  
    • omicron
      By omicron
      How do you perform a nested loop function with a multidimensional array from 2 lists.
      for i in list1
      (open file) extract variable
          while open for i in list 2
          (open file2) extract variable
       
      var1 + var2 = (search term)

      The list sizes will more than likely consist of different lengths.
       
      What is the best approach to accomplishing this method?
             
    • omicron
      By omicron
      Hello!

      I am working on a function that I am just getting lost on. The goal is a multiple nested loop.

      Here are the steps:
      Contents of file1.txt::
      [topic] var1=Name var2=OtherName var3=SomeotheName Contents of file2.txt::
      [subTopic] top=sub1 top2=sub2 top3=sub3 The Shell I am working from::
      #include <file.au3> $file = "c:\yourfile.txt" FileOpen($file, 0) For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) msgbox(0,'','the line ' & $i & ' is ' & $line) Next FileClose($file) Understanding however that the "msgbox" needs to then become a variable. in example the following::
      $file = "c:\yourfile.txt" FileOpen($file, 0) While true( prog.exe is running && "WinName" is open) do For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) ;Open File to log "current location of file 1" FileWriteLine ("filename", $i & ' is ' & $line) var = $line Next $file2 = "c:\yourfile.txt" FileOpen($file, 0) For $i = 1 to _FileCountLines($file) $line = FileReadLine($file, $i) ; OpenFile to log "Current location of file 2" FileWriteLine ("filename", $i & ' is ' & $line) Next FileClose($file2) FileClose($file) The goal in written form is the following ::

      While in "OpenWindow"
          read from file 1 starting at line 1 until end of file.
         file 1 is a list of names to be searched.
         With $line selected, add this element to the element in file 2.
       
      The search of a variables in list 1 and list 2 differ on the amount of posts that day. (This is not a web based platform, it is a game) I need to search 2 names and take a screenshot of the out put. The sizes of the names list depend on the activity of names at the time of search.
      This loop continues until all the names from both lists have been searched. Mostly in the format of::
      File1= item
      File2= Vendor
       
      Item + Vendor  ( Capture screen, scroll) -- Not sure how to detect if I need to scroll)
       
      Thank you for your help and support!
    • nooneclose
      By nooneclose
      I need help turning this string "20180913221626" into a formatted time string.
      I need to go from this: 20180913221626
      to this: 09/13/2018 10:16 PM
      I do not always know what the date will be so I can not just use a variable I need to actually convert/format. 
      I did see an older post in the forms that was basically the same question only the other guy did not post the working code and I can not figure out how to use _AD_GetObjectProperties properly to get what I want. 
      As always any help would be appreciated. 
      Here is the code I use to find the date, but it always gives me the unformatted version. 
      ;retrieve the items object $oItem = $oOutlook.Session.GetItemFromID($aItems[1][0], Default) $oItem.GetInspector $eSentOn = $oItem.SentOn ; When was the email sent? MsgBox("", "Sent On of the email", $eSentOn) ;******************************************************************************* ; Formats the date and time from the email ;******************************************************************************* ;Local $fDatenTime = _DateTimeFormat($eSentOn, 1) ;MsgBox("", "Formatted email time", $fDatenTime) $aProperties = _AD_GetObjectProperties($eSentOn) _ArrayDisplay($aProperties, "Did the conversion work?")  
    • Skeletor
      By Skeletor
      Hi Virtual People,
      My array works perfectly fine. However, what is the best practice if the line in the array doesn't have the correct amount of columns and if I can add a placeholder?

       
      For $count = 1 To _FileCountLines($FileRead1) Step 1 $string = FileReadLine($FileRead1, $count) $input = StringSplit($string, ",", 1) $value1 = $input[1] $value2 = $input[2] $value3 = $input[3] _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value2, "A1") _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value1, "B1") _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $value3, "C1") Next  
×