[Solved] Extracting text from string and reinsert it.

Recommended Posts

Hi, I'm looking for a way to extract specific binary text data from string(except between "[", "]") and convert it.

And put it back to text. How can I do it? Can someone help me?

```Example

\$text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82"

Rearrange the text like below

[1F010005300020FF]
0x82CD0A            =>  StringToBinary(0x82CD0A) == A
[030005300020FF]
0x8177          =>  StringToBinary(0x8177) == B
[1F12010000E6300020FF]
0x8178          =>  StringToBinary(0x8178) == C
[1F030000300020FF]
0x82F00A8A6F82A682DC82  =>  StringToBinary(0x82F00A8A6F82A682DC82) == D

\$output = "[1F010005300020FF]A[030005300020FF]B[1F12010000E6300020FF]C[1F030000300020FF]D"```

Edited by carl1905
Share on other sites

Hi, im maybe wrong but try that :

```\$text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82"

#include <Array.au3>

If IsArray(\$aArr) = 0 Then Return SetError(1, 0, -1) ; Filter out non-array
If \$iNumColToAdd < 1 Then Return SetError(2, 0, -1) ; \$iNumColToAdd must be greater than zero to add a column.
If UBound(\$aArr, 0) > 2 Then Return SetError(3, 0, -1) ; Only allows a 1d or 2d array pass this line.

If UBound(\$aArr, 0) = 1 Then ; ====== For 1d array ========
Local \$aRet[UBound(\$aArr)][\$iNumColToAdd + 1] ; Create new 2d array.
For \$r = 0 To UBound(\$aArr) - 1
\$aRet[\$r][0] = \$aArr[\$r]
Next
Else ; ======= For 2d array ============
Local \$aRet = \$aArr ; So that ByRef \$aArr is not altered outside of function.
ReDim \$aRet[UBound(\$aRet)][UBound(\$aRet, 2) + \$iNumColToAdd] ; ReDim 2d array only.
EndIf

Return \$aRet

\$split = StringSplit(\$text,"[]")
_ArrayDisplay(\$split, "v1")

For \$i = 1 To Ubound(\$split) - 1
\$split[\$i][1] = BinaryToString("0x" & \$split[\$i][0])
\$i=\$i+1
Next
_ArrayDisplay(\$split, "v2")

\$fill = ""
For \$i = 2 to Ubound(\$split) - 1
\$fill = \$fill & "[" & \$split[\$i][0] & "]" & \$split[\$i+1][1]
\$i=\$i+1
Next
msgbox(0,"Output",\$fill)```

Edit :

```\$split[\$i][1] = BinaryToString("0x" & \$split[\$i][0], 2);<======= \$SB_UTF16LE (2) = binary data is UTF16 Little Endian
\$split[\$i][1] = BinaryToString("0x" & \$split[\$i][0], 3);<======= \$SB_UTF16BE (3) = binary data is UTF16 Big Endian```

Edited by Synapsee
Share on other sites

Check out StringRegExpReplace()

Share on other sites
```\$text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82"

\$text = StringReplace(\$text, "]82CD0A[", "]A[")             ;A
\$text = StringReplace(\$text, "]8177[", "]B[")               ;B
\$text = StringReplace(\$text, "]8178[", "]C[")               ;C
\$text = StringReplace(\$text, "]82F00A8A6F82A682DC82", "]D") ;D

ConsoleWrite(\$text & @CRLF)```

Edited by AndyG
Share on other sites
5 hours ago, Synapsee said:

Hi, im maybe wrong but try that :

Thanks for your reply. However, the last one word is missing. And can the output text be arranged in row? Not column.

```#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <FileConstants.au3>
Global Const \$CP_SHIFT_JIS = 932

\$text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82"

Func _CodepageStructToString(\$tText, \$iCodepage)
Local \$aResult = DllCall("kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"ptr", 0, "int", 0)
Local \$tWstr = DllStructCreate("wchar[" & \$aResult[0] & "]")
\$aResult = DllCall("Kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"struct*", \$tWstr, "int", \$aResult[0])
Return DllStructGetData(\$tWstr, 1)
EndFunc

If IsArray(\$aArr) = 0 Then Return SetError(1, 0, -1) ; Filter out non-array
If \$iNumColToAdd < 1 Then Return SetError(2, 0, -1) ; \$iNumColToAdd must be greater than zero to add a column.
If UBound(\$aArr, 0) > 2 Then Return SetError(3, 0, -1) ; Only allows a 1d or 2d array pass this line.

If UBound(\$aArr, 0) = 1 Then ; ====== For 1d array ========
Local \$aRet[UBound(\$aArr)][\$iNumColToAdd + 1] ; Create new 2d array.
For \$r = 0 To UBound(\$aArr) - 1
\$aRet[\$r][0] = \$aArr[\$r]
Next
Else ; ======= For 2d array ============
Local \$aRet = \$aArr ; So that ByRef \$aArr is not altered outside of function.
ReDim \$aRet[UBound(\$aRet)][UBound(\$aRet, 2) + \$iNumColToAdd] ; ReDim 2d array only.
EndIf

Return \$aRet

\$split = StringSplit(\$text,"[]")
\$Str = ""
\$fill = ""

For \$i = 1 To Ubound(\$split) - 1
\$split[\$i][1] = Binary("0x" & \$split[\$i][0])
;msgbox(0,"Output",\$split[\$i][1])
Local \$tInp = DllStructCreate("byte[" & BinaryLen(\$split[\$i][1]) & "]")
DllStructSetData(\$tInp, 1, \$split[\$i][1])
Local \$Str  = _CodepageStructToString(\$tInp, \$CP_SHIFT_JIS)
\$Str  = StringRegExpReplace(\$Str ,@CRLF,"<cf>")
\$Str  = StringRegExpReplace(\$Str ,@LF,"<lf>")
\$Str  = StringRegExpReplace(\$Str ,@CR,"<cr>")
\$split[\$i][1] = \$Str  & @CRLF
\$i=\$i+1
Next

\$fill = ""
For \$i = 2 to Ubound(\$split) - 1
\$fill = \$fill & "[" & \$split[\$i][0] & "]" & \$split[\$i+1][1]
\$i=\$i+1
Next
msgbox(0,"Output",\$fill)
FileWrite ("test.txt", \$fill)
FileClose ("test.txt")
TrayTip ("Exporter", "Finish!", 3)
sleep (3000)```

Edited by carl1905
Share on other sites

what is the "test.txt" expected ? u want that :

Quote

[1F010005300020FF][030005300020FF][1F12010000E6300020FF][1F030000300020FF]

は<lf>『』を<lf>覚えま・

Or something else ?

Edited by Synapsee
Share on other sites
1 hour ago, Synapsee said:

what is the "test.txt" expected ? u want that :

Or something else ?

The one that I want is this form.

`[1F010005300020FF]は<lf>[030005300020FF]『[1F12010000E6300020FF]』[1F030000300020FF]を<lf>覚えま・`

Edited by carl1905
Share on other sites

Ah, I missed some last three byte. 0xB582BD

`text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82B582BD"`

So, this is the corrected form.

`[1F010005300020FF]は<lf>[030005300020FF]『[1F12010000E6300020FF]』[1F030000300020FF]を<lf>覚えました`

Edited by carl1905
Share on other sites

Not sure, but try that one :

```Local \$text = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82"
\$out = Execute('"' & StringRegExpReplace(\$text, "\]\K([^\]]+)(?=\[|\$)",  """ & BinaryToString(""0x\1"") & """) & '"')
MsgBox(0, "", \$out)```

Share on other sites

Another examples..

```\$text2 = "[09020000390011300020FF]82BB82A482CB81428DC58CE382CC90B897EC82C60A8C5F96F182B782E9914F82C90C[1F090200003A0011300020FF]90D882E897A382B582BD82A082C682CC90A28A4582C982C282A282C40A92B282D782C482A882A282BD95FB82AA82A282A282ED82CB"

\$result2 = "[09020000390011300020FF]そうね。最後の精霊と<lf>契約する前に�[1F090200003A0011300020FF]切り離したあとの世界について<lf>調べておいた方がいいわね"

\$result3 = "[090200003B0011300020FF]これは・・・<lf>以前より激しくなっていないか？"```

However, \$test3 starts with "814581458145" but at the \$result3 it disappears.

Maybe this is the corrected form.

`#result3_fix = "・・・[090200003B0011300020FF]これは・・・<lf>以前より激しくなっていないか？"`

Edited by carl1905
Share on other sites
```#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <FileConstants.au3>

Global Const \$CP_SHIFT_JIS = 932

Func _CodepageStructToString(\$tText, \$iCodepage)
Local \$aResult = DllCall("kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"ptr", 0, "int", 0)
Local \$tWstr = DllStructCreate("wchar[" & \$aResult[0] & "]")
\$aResult = DllCall("Kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"struct*", \$tWstr, "int", \$aResult[0])
Return DllStructGetData(\$tWstr, 1)
EndFunc

If IsArray(\$aArr) = 0 Then Return SetError(1, 0, -1) ; Filter out non-array
If \$iNumColToAdd < 1 Then Return SetError(2, 0, -1) ; \$iNumColToAdd must be greater than zero to add a column.
If UBound(\$aArr, 0) > 2 Then Return SetError(3, 0, -1) ; Only allows a 1d or 2d array pass this line.

If UBound(\$aArr, 0) = 1 Then ; ====== For 1d array ========
Local \$aRet[UBound(\$aArr)][\$iNumColToAdd + 1] ; Create new 2d array.
For \$r = 0 To UBound(\$aArr) - 1
\$aRet[\$r][0] = \$aArr[\$r]
Next
Else ; ======= For 2d array ============
Local \$aRet = \$aArr ; So that ByRef \$aArr is not altered outside of function.
ReDim \$aRet[UBound(\$aRet)][UBound(\$aRet, 2) + \$iNumColToAdd] ; ReDim 2d array only.
EndIf

Return \$aRet

\$text1 = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82B582BD"
\$text2 = "[09020000390011300020FF]82BB82A482CB81428DC58CE382CC90B897EC82C60A8C5F96F182B782E9914F82C90C[1F090200003A0011300020FF]90D882E897A382B582BD82A082C682CC90A28A4582C982C282A282C40A92B282D782C482A882A282BD95FB82AA82A282A282ED82CB"

;v1 without @CRLF
\$file = "test without crlf.txt"
\$text = \$text1 & \$text2 & \$text3
MainFunc(\$text, \$file)

;v2 with @CRLF
\$file = "test with crlf.txt"
MainFunc(\$text1, \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)
MainFunc(\$text2 , \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)
MainFunc(\$text3, \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)

Func MainFunc(\$text, \$file)

\$split = StringSplit(\$text,"[]")
\$Str = ""
\$fill = ""
;_ArrayDisplay(\$split)

if StringInStr(\$text, "[") = 1 Then
\$y = 3
Else
\$y = 1
EndIf

For \$i = \$y-1 To Ubound(\$split) - 1
\$split[\$i][1] = "[" & \$split[\$i][0] & "]"
\$i=\$i+1
\$split[\$i][1] = Binary("0x" & \$split[\$i][0])
;msgbox(0,"Output",\$split[\$i][1])
Local \$tInp = DllStructCreate("byte[" & BinaryLen(\$split[\$i][1]) & "]")
DllStructSetData(\$tInp, 1, \$split[\$i][1])
Local \$Str  = _CodepageStructToString(\$tInp, \$CP_SHIFT_JIS)
\$Str  = StringRegExpReplace(\$Str ,@CRLF,"<cf>")
\$Str  = StringRegExpReplace(\$Str ,@LF,"<lf>")
\$Str  = StringRegExpReplace(\$Str ,@CR,"<cr>")
\$split[\$i][1] = \$Str
Next
;_ArrayDisplay(\$split)

\$fill = ""
For \$i = 1 to Ubound(\$split) - 1
\$fill = \$fill & "" & \$split[\$i][1]
Next

;msgbox(0,"Output",\$fill)

FileWrite (\$file, \$fill)
FileClose (\$file)

EndFunc```

Share on other sites
10 hours ago, Synapsee said:
```#include <Array.au3>
#include <MsgBoxConstants.au3>
#include <FileConstants.au3>

Global Const \$CP_SHIFT_JIS = 932

Func _CodepageStructToString(\$tText, \$iCodepage)
Local \$aResult = DllCall("kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"ptr", 0, "int", 0)
Local \$tWstr = DllStructCreate("wchar[" & \$aResult[0] & "]")
\$aResult = DllCall("Kernel32.dll", "int", "MultiByteToWideChar", "uint", \$iCodepage, "dword", 0, "struct*", \$tText, "int", DllStructGetSize(\$tText), _
"struct*", \$tWstr, "int", \$aResult[0])
Return DllStructGetData(\$tWstr, 1)
EndFunc

If IsArray(\$aArr) = 0 Then Return SetError(1, 0, -1) ; Filter out non-array
If \$iNumColToAdd < 1 Then Return SetError(2, 0, -1) ; \$iNumColToAdd must be greater than zero to add a column.
If UBound(\$aArr, 0) > 2 Then Return SetError(3, 0, -1) ; Only allows a 1d or 2d array pass this line.

If UBound(\$aArr, 0) = 1 Then ; ====== For 1d array ========
Local \$aRet[UBound(\$aArr)][\$iNumColToAdd + 1] ; Create new 2d array.
For \$r = 0 To UBound(\$aArr) - 1
\$aRet[\$r][0] = \$aArr[\$r]
Next
Else ; ======= For 2d array ============
Local \$aRet = \$aArr ; So that ByRef \$aArr is not altered outside of function.
ReDim \$aRet[UBound(\$aRet)][UBound(\$aRet, 2) + \$iNumColToAdd] ; ReDim 2d array only.
EndIf

Return \$aRet

\$text1 = "[1F010005300020FF]82CD0A[030005300020FF]8177[1F12010000E6300020FF]8178[1F030000300020FF]82F00A8A6F82A682DC82B582BD"
\$text2 = "[09020000390011300020FF]82BB82A482CB81428DC58CE382CC90B897EC82C60A8C5F96F182B782E9914F82C90C[1F090200003A0011300020FF]90D882E897A382B582BD82A082C682CC90A28A4582C982C282A282C40A92B282D782C482A882A282BD95FB82AA82A282A282ED82CB"

;v1 without @CRLF
\$file = "test without crlf.txt"
\$text = \$text1 & \$text2 & \$text3
MainFunc(\$text, \$file)

;v2 with @CRLF
\$file = "test with crlf.txt"
MainFunc(\$text1, \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)
MainFunc(\$text2 , \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)
MainFunc(\$text3, \$file)
FileWrite (\$file, @CRLF)
FileClose (\$file)

Func MainFunc(\$text, \$file)

\$split = StringSplit(\$text,"[]")
\$Str = ""
\$fill = ""
;_ArrayDisplay(\$split)

if StringInStr(\$text, "[") = 1 Then
\$y = 3
Else
\$y = 1
EndIf

For \$i = \$y-1 To Ubound(\$split) - 1
\$split[\$i][1] = "[" & \$split[\$i][0] & "]"
\$i=\$i+1
\$split[\$i][1] = Binary("0x" & \$split[\$i][0])
;msgbox(0,"Output",\$split[\$i][1])
Local \$tInp = DllStructCreate("byte[" & BinaryLen(\$split[\$i][1]) & "]")
DllStructSetData(\$tInp, 1, \$split[\$i][1])
Local \$Str  = _CodepageStructToString(\$tInp, \$CP_SHIFT_JIS)
\$Str  = StringRegExpReplace(\$Str ,@CRLF,"<cf>")
\$Str  = StringRegExpReplace(\$Str ,@LF,"<lf>")
\$Str  = StringRegExpReplace(\$Str ,@CR,"<cr>")
\$split[\$i][1] = \$Str
Next
;_ArrayDisplay(\$split)

\$fill = ""
For \$i = 1 to Ubound(\$split) - 1
\$fill = \$fill & "" & \$split[\$i][1]
Next

;msgbox(0,"Output",\$fill)

FileWrite (\$file, \$fill)
FileClose (\$file)

EndFunc```

Thank you!!

Create an account

Register a new account

• Similar Content

• By DJ143
I have a autoit exe file which is used in upload/browse file functionality.  This has been integrated with selenium framework and I am invoking the autoit exe using Java process and runtime.
Now the issue is when I run the scripts and invoke the autoit exe in local it works perfectly.  But when I use selenium grid or jenkins to run the scripts in another windows server it is not working.
Can anyone please suggest any solution for this?
• By Hermes
Hello, the script below will read column A from an excel file - and if a value matches in the browser, it will click the corresponding link and click on a specific button to paste the data, then writes "Completed" in Column B. It will continue to read from the excel file and do the same thing for all the remaining rows.
What i am trying figure out now is if the excel crashes while the script/loop is running, I want to relaunch the excel file continue to the last row before the excel crashed. So if the value of column B is not marked as "completed", it should continue from that row
Appreciate any help that I can get to achieve this.
table1.html test.xlsx

• Hello ,
I am trying to use Websockets in AutoIt.
It is to fetch live stock market prices , API is provided and documentation available for python language.
The link for the code snippet is :
https://symphonyfintech.com/xts-market-data-front-end-api-v2/#tag/Introduction
https://symphonyfintech.com/xts-market-data-front-end-api-v2/#tag/Instruments/paths/~1instruments~1subscription/post

https://github.com/symphonyfintech/xts-pythonclient-api-sdk

Second Link is to subscribe to a list of ExchangeInstruments.
Now I would like to get live stock ltp (LastTradedPrice) for a few stocks whose "ExchangeInstrumentID" I know.
I am able to use the WinHttp object to perform actions using simple codes like below :
I have the secretKey and appkey and can generate the needed token. And get the unique ExchangeInstrumentID.

Below code is just for example of how I am using WinHttp. Unrelated to socket part.
Global \$InteractiveAPItoken = IniRead(@ScriptDir & "\Config.ini", "token", "InteractiveAPItoken", "NA") \$baseurl = "https://brokerlink.com/interactive/" \$functionurl = "orders" \$oHTTP = ObjCreate("winhttp.winhttprequest.5.1") \$oHTTP.Open("POST", \$baseurl & \$functionurl, False) \$oHTTP.SetRequestHeader("Content-Type", "application/json;charset=UTF-8") \$oHTTP.SetRequestHeader("authorization", \$InteractiveAPItoken) \$pD = '{ "exchangeSegment": "NSEFO", "exchangeInstrumentID": ' & \$exchangeInstrumentID & ', "productType": "' & \$producttype & '", "orderType": "MARKET", "orderSide": "' & \$orderside & '", "timeInForce": "DAY", "disclosedQuantity": 0, "orderQuantity": ' & \$qty & ', "limitPrice": 0, "stopPrice": 0, "orderUniqueIdentifier": "' & \$orderidentifier & '"}' \$oHTTP.Send(\$pD) \$oReceived = \$oHTTP.ResponseText \$oStatusCode = \$oHTTP.Status

But am struggling to understand and use socket.
Would be of great help if you can have a look at the link mentioned above and help with the code sample for AutoIt.
To connect and listen to a socket.
Thanks a lot

• By Hermes
Hi, I have a site that has the following elements below:
<div>More element here</div> <div>More element here</div> <div>More element here</div> When I do this in Auto It:
Local \$oSelectDiv = _WD_FindElement(\$sSession, \$_WD_LOCATOR_ByCSSSelector, "div") _WD_HighlightElement(\$sSession, \$oSelectDiv, 1) I also tried to add [3], but it doesnt seems to work:
Local \$oSelectDiv = _WD_FindElement(\$sSession, \$_WD_LOCATOR_ByCSSSelector, "div[3]") _WD_HighlightElement(\$sSession, \$oSelectDiv, 1) It always highlight the first one, but I am trying to highlight the 3rd in the list. Is there anyway to select the 3rd div without having to add any class/id in the divs, and without using XPATH? The structure of the elements in that site were built that way.
• By meety
My au3 script program needs administrator privileges on win10 to be executed correctly, because it needs to be added to the boot---Script code:RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run", @ScriptName, "REG_SZ", @ScriptFullPath)
I need to let the program automatically get administrator privileges, so I use a function of #RequireAdmin. Although the program can be added to the boot, but does not execute after system boot up? why is that?
What should I do?
--------------------------------------------------------------------
Update:
I found that after using the #RequireAdmin function, the program cannot be executed after system boot up.
An example is given below. after it is compiled, it will not be executed after system boot up in the following two ways.
2. RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run", @ScriptName, "REG_SZ", @ScriptFullPath)
why is that?
example
#include <MsgBoxConstants.au3>