Jump to content
Sign in to follow this  
diabolik

Tera Term -- how to filter text out of a file the right way?

Recommended Posts

diabolik

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

 

 

Share this post


Link to post
Share on other sites
Melba23

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._______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

 

Share this post


Link to post
Share on other sites
diabolik

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.  :o(

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

Share this post


Link to post
Share on other sites
jchd

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 here
RegExp tutorial: enough to get started
PCRE 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)

Share this post


Link to post
Share on other sites
Melba23

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._______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

 

Share this post


Link to post
Share on other sites
JohnOne

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.

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  

×