In a task set to Find text in a file, getting Syntax Error: Script error: "(10538) Operand/operator type mismatch." at script line 2.

The Variables tab show the correct Value for the find text command, but the Get subtext command is where the error occurs.

See code.

The code for Get Sub Text was copied from a Sample script and changed to the variables in this script.

Thank you for any help

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7

Task Steps: (Right click, Select All, Copy to copy to the clipboard. Steps can then be pasted into the AutoMate Task Builder)
<!-- Start process --> <AMVARIABLE NAME="pager_1" DESCRIPTION="Phone">1111111111@vtext.com</AMVARIABLE> <AMVARIABLE NAME="pager_2" DESCRIPTION="RT Pager">5555555555@page.metrocall.com</AMVARIABLE> <AMVARIABLE NAME="pager_3" DESCRIPTION="RT Pager">6666666666@page.metrocall.com</AMVARIABLE> <AMVARIABLE NAME="pager_email">email@test.mail</AMVARIABLE> <AMVARIABLE NAME="increment">1</AMVARIABLE> <!-- A method of reading a file line by line. Make sure the text file is copied to the root of your C:\ drive or change the path to the file. --> <AMVARIABLE NAME="myfile"></AMVARIABLE> <AMFILEREAD FILE="e:\ftp\rt_orders2\2799740.txt" RESULTVARIABLE="myfile" /> <AMVARIABLE NAME="curdate"></AMVARIABLE> <AMTEXTFORMATDATETIME DATETIMEFORMAT="mm/dd/yyyy h:nn:ss" 12HOURFORMAT="NO" RESULTVARIABLE="curdate" /> <AMVARIABLE NAME="Index1"></AMVARIABLE> <AMVARIABLE NAME="Index2"></AMVARIABLE> <AMVARIABLE NAME="Index3"></AMVARIABLE> <AMVARIABLE NAME="Index4"></AMVARIABLE> <AMVARIABLE NAME="Index5"></AMVARIABLE> <AMVARIABLE NAME="Index6"></AMVARIABLE> <AMVARIABLE NAME="Index7"></AMVARIABLE> <AMVARIABLE NAME="Freq"></AMVARIABLE> <AMFINDTEXT TEXT="%myfile%" FIND="NAME:" FOUNDTEXTVARIABLE="Index1" /> <AMFINDTEXT TEXT="%myfile%" FIND="M00" FOUNDTEXTVARIABLE="Index2" /> <AMTEXTGETSUBTEXT TEXT="%myfile%" STARTPOSITION="%Index1%" LENGTH="%Index2-Index1%" RESULTVARIABLE="patient" /> <AMFINDTEXT TEXT="%myfile%" FIND="PHYS: " USECASE="YES" FOUNDTEXTVARIABLE="Index3" /> <AMFINDTEXT TEXT="%myfile%" FIND="TYPE:" FOUNDTEXTVARIABLE="Index4" /> <AMTEXTGETSUBTEXT TEXT="%myfile%" STARTPOSITION="%Index3%" LENGTH="%Index4-Index3%" RESULTVARIABLE="attending" /> <AMFINDTEXT TEXT="%myfile%" FIND="ROOM: " USECASE="YES" FOUNDTEXTVARIABLE="Index5" /> <AMFINDTEXT TEXT="%myfile%" FIND="LOC:" FOUNDTEXTVARIABLE="Index6" /> <AMTEXTGETSUBTEXT TEXT="%myfile%" STARTPOSITION="%Index5%" LENGTH="%Index6-Index5%" RESULTVARIABLE="roomnumber" /> <AMFINDTEXT TEXT="%myfile%" FIND="Frequency " RESULTVARIABLE="Index7" USECASE="YES" FOUNDTEXTVARIABLE="Index7" /> <AMTEXTGETSUBTEXT TEXT="%myfile%" STARTPOSITION="%Index7%" LENGTH="25" RESULTVARIABLE="Freq" /> <AMSENDEMAIL TO="%pager_email%" SUBJECT="%&quot;New Order &quot; &amp; roomnumber &amp;&quot; &quot;&amp; freq%" FROM="rt@mr.org"></AMSENDEMAIL> <AMFILEWRITE FILE="E:\FTP\rt_orders2\LogFile\rt_orders_log.txt">%curdate &amp;&quot; - &quot;&amp; roomnumber &amp;&quot; - &quot;&amp; attending &amp;&quot; - &quot;&amp; patient &amp;&quot; - &quot;&amp; freq%</AMFILEWRITE>

Hello Laurie,

 

Can you elaborate a bit more? What step is the one that fails? You have a few Get Sub Text actions.

Category Survey AutoMate 7 version: Windows version:

-------------------------
Mary Manzano | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

I will test later, but just from your task, it looks like you store a 'text' piece that is found in your index variables, not the index position. To have the position in the variable, it shoud look like this:
RESULTVARIABLE="varname"

If you open teh action in the task builder, you should be easily able to correct this.

Category Survey

-------------------------


Edited: 10/29/2014 at 02:29 AM by Gijsberth de Ruiter

I changed the task to store the variable with first index rather than store the text. The script still fails at the Get Text task but there is no error now. The output just shows the step in Red, then ends the task.
The value for the variable is now a position number. The number of characters for the text between the two variables is correct.

Laurie

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7

Laurie,
If I look at your task, you have result variables in teh getsubtext action that are not craeted. You need to create the variables first, e.g. roomnumber, attending, patient and freq. Maybe I missed one.
Gijs

Category Survey

-------------------------

Gijs

Thank you,

I had disabled those variables and didn't include them in the code attached.

The script is working with those enabled.

Appreciate your help.
Laurie

Category Survey AutoMate 7 version: 7.0.8 Windows version: Windows 7