diabolik Posted March 17, 2014 Posted March 17, 2014 Hi there, i'm currently forced to adapt a rather old-fashioned script based on "procomm plus" to Tera Term. Unfortunately, despite a really impressive documentation i can't find a solution for my problem. That's why i'm asking the members of this forum for help. I'm trying the following: 1. I get a search string 'inputstr' via the inputBox 2. I read in a text-file, line by line, with "filereadln" into the variable 'data' 3. And i know how to find the pattern of the inputstr inside data with "strmatch". So far so good. Up to here i've come and it works. Now i have to filter. Which means: 4. If 'data' contains 'inputstr' then the phone number has to be extracted and put into another variable. And this is the point where i don't know how to succeed. The lines of the text file have the following repetitive pattern: <numeric line identifier>;<phone number>;;;<data description> Can anybody give me a hint, how to tell Tera Term to filter exactly the phone number when there is a matching identifier? Thanks in advance! regards diabolik
Moderators Melba23 Posted March 17, 2014 Moderators Posted March 17, 2014 diabolik,Welcome to the AutoIt forum. That sounds like a pretty easy task for a Regex - something like this should work:$sLine = "<numeric line identifier>;<phone number>;;;<data description>" $sNumber = StringRegExpReplace($sLine, ".*;<(.*)>;;;.*", "$1") MsgBox(0, "Hi", $sNumber)Any use? M23 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 columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
diabolik Posted March 17, 2014 Author Posted March 17, 2014 Hello M23 Unfortunately, there seems to be a lot more i have to learn about Tera Term syntax. How do I initialise those variables like $sLine and $sNumber? I allways run into an error. ( Here's my source code so far: ######################################## ; this is the inputBox for the searchString ; inputbox 'identifier:' 'enter the indentifier' ; write the result in the system variable inputstr ; sendln inputstr ; debug-box ; messagebox inputstr 'entered string' ; this is the file to be searched in ; filename = 'numberBox.txt' ; this is the command to access the file ; fileopen fhandle filename 0 ; starting a loop. the loop will be stopped when the file's end is reached or a match occurrs. ; :loop ; start reading line by line ; filereadln fhandle data ; search in the current line for the entered identifier ; $sLine = data <---- BANG $sNumber = StringRegExpReplace($sLine, ".*;<(.*)>;;;.*", "$1") MsgBox(0, "Hi", $sNumber) ; if the file's end is reached, leave the loop and close the file ; if result goto fclose ; loop. read the next line. ; goto loop ; close the file ; :fclose fileclose fhandle ######################################## Sorry! I'm quit new to scripting... regards Diabolik
jchd Posted March 17, 2014 Posted March 17, 2014 How do you imagine mixing AutoIt statements inside a Tera Term script? This wonderful site allows debugging and testing regular expressions (many flavors available). An absolute must have in your bookmarks.Another excellent RegExp tutorial. Don't forget downloading your copy of up-to-date pcretest.exe and pcregrep.exe hereRegExp tutorial: enough to get startedPCRE v8.33 regexp documentation latest available release and currently implemented in AutoIt beta. SQLitespeed is another feature-rich premier SQLite manager (includes import/export). Well worth a try.SQLite Expert (freeware Personal Edition or payware Pro version) is a very useful SQLite database manager.An excellent eBook covering almost every aspect of SQLite3: a must-read for anyone doing serious work.SQL tutorial (covers "generic" SQL, but most of it applies to SQLite as well)A work-in-progress SQLite3 tutorial. Don't miss other LxyzTHW pages!SQLite official website with full documentation (may be newer than the SQLite library that comes standard with AutoIt)
Moderators Melba23 Posted March 17, 2014 Moderators Posted March 17, 2014 diabolik,That is AutoIt code and this is a forum which helps you code in the AutoIt language - which is what I assumed you wanted to do. Now I have googled around a bit, it seems you are using Tera Term's own macro languge - so I suggest you post on a Tera Term forum. M23 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 columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
JohnOne Posted March 17, 2014 Posted March 17, 2014 This is autoit, not C or C++ or anything else. I suggest that every time you ant to write something into your code, like fclose or goto, you search for it in the help file, they wont be there, meaning they do not exist in autoit. AutoIt Absolute Beginners Require a serial Pause Script Video Tutorials by Morthawt ipify Monkey's are, like, natures humans.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now