Hello,
I need to create veriable's for a couple of lines that are delimited.
How do I tell the text extraction line it's on ie. line 27 position 1,2,3 or so the delimited line item can go from 1 item to 100
and is there a way to tell the text extraction how many items will need to be delimited to do this automatically rather than creating 100 veriables.
Line 41 is the amount of items that are delimited.
please see attached text file.
Thanks!!!
Text extraction of a delimited file
Re: Text extraction of a delimited file
To extract single line from the text see TXT Extract Line action
Oleg Yershov
Re: Text extraction of a delimited file
MYEMAILNAME@yahoo.com
1070
ST SUFFIX
SHIP2NAME
SHIP2ADDRESS1
SHIP2ADDRESS2
SHIP2ADDRESS3
SHIP2ADDRESS4
17251
17252
17252
37838
1
RRM
JOSE GUZMAN
OT
OUR TRUCK
02
PJ03/31
SC%
RM
N30
NET 30 DAYS
TERM%
17293
VENDOR#
63985*1ý63986*1ý63987*1ýCý57149*1ý63989*1ý23425*1
1/2 X 30'UHF SEALANT ENTERTECHý1/4 X 50'UHF SEALANT ENTERTECHý3/8 X 50'UHF SEALANT ENTERTECHýýý21/2 COOPLOK STD "E" GSKT ONLY
1ý1ý1ýý1ý1ý1
MU35ýMU35ýMU35ýýMU50ýMU50ýMU40
193349ý108507ý193349ýý3515ý4061ý7634
ýýýý1ýý1
250000ý155650ý250000ýý10750ý12980ý10200
125000ý70150ý125000ýý1740ý2012ý4550
1ý1ý1ýý10ý10ý10
1ý1ý1ýý10ý10ý10
1ý1ý1ýý10ý10ý10
0ý0ý0ýý0ý0ý0
1ý1ý1ýý10ý10ý10
TýTýTýTýTýTýT
7
64731
40317
17263
17263
17256
MRD
TAXED?
TAXNUMBER
4813
RESERVED
RESERVED
7373
174363
MY COMPANY NAME
16195 STEPHANS STREET
CITY OF INDUSTRY, AZ 91745
RESERVED
JOSE GUZMAN
555-1234
555-1233
1070
ST SUFFIX
SHIP2NAME
SHIP2ADDRESS1
SHIP2ADDRESS2
SHIP2ADDRESS3
SHIP2ADDRESS4
17251
17252
17252
37838
1
RRM
JOSE GUZMAN
OT
OUR TRUCK
02
PJ03/31
SC%
RM
N30
NET 30 DAYS
TERM%
17293
VENDOR#
63985*1ý63986*1ý63987*1ýCý57149*1ý63989*1ý23425*1
1/2 X 30'UHF SEALANT ENTERTECHý1/4 X 50'UHF SEALANT ENTERTECHý3/8 X 50'UHF SEALANT ENTERTECHýýý21/2 COOPLOK STD "E" GSKT ONLY
1ý1ý1ýý1ý1ý1
MU35ýMU35ýMU35ýýMU50ýMU50ýMU40
193349ý108507ý193349ýý3515ý4061ý7634
ýýýý1ýý1
250000ý155650ý250000ýý10750ý12980ý10200
125000ý70150ý125000ýý1740ý2012ý4550
1ý1ý1ýý10ý10ý10
1ý1ý1ýý10ý10ý10
1ý1ý1ýý10ý10ý10
0ý0ý0ýý0ý0ý0
1ý1ý1ýý10ý10ý10
TýTýTýTýTýTýT
7
64731
40317
17263
17263
17256
MRD
TAXED?
TAXNUMBER
4813
RESERVED
RESERVED
7373
174363
MY COMPANY NAME
16195 STEPHANS STREET
CITY OF INDUSTRY, AZ 91745
RESERVED
JOSE GUZMAN
555-1234
555-1233
Re: Text extraction of a delimited file
this is what I have so far
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|317717699
Comment=STRINGLIST
ContinueOnError=INTEGER|0
Events=FOLDER
ExternalName=STRING|"Task13"
Hide=INTEGER|0
ID=INTEGER|1985918298
LocalVariables=STRING|"ACCOUNTNUMBER=2,BIDCOST=43,BIDVALUE=42,COMMENT=28,CONTACT=15,CONTACT=15,COST=34,CUSTOMERADDR1=56,CUSTOMERADDR2=57,CUSTOMERADDR3=58,CUSTOMERNAME=55,CUSTPO=12,DATESHIP=11,DATESHIPPED=46,EMAIL=1,EXEMPT=49,FAX=61,FOB=18,FREIGHT=53,FUTURE=10,FUTUREDATE=45,HANDLING=54,INSTRUCTIONS=19,INVDATE=44,INVOICEDATE=9,INVOICENUMBER=51,LISTPRICE=33,NETPRICE=31,NUMOFITEMS=41,ONORDER=35,ONPICK=37,ONPICK=37,PER=29,PHONE=60,PRCDE=30,PRODUCT=27,RESERVED1=32,RESERVED2=52,SALESMEN=21,SCPERCENT=20,SHIP2ADDRESS1=5,SHIP2ADDRESS2=6,SHIP2ADDRESS3=7,SHIP2ADDRESS4=8,SHIPTONAME=4,SUFFIX=3,TAXABLE=48,TAXAMT=51,TAXCDE=47,TAXRATE=50,TERMDATE=25,TERMDESC=23,TERMPERCENT=24,TERMS=22,TOBO=38,TOPICK=37,VENDOR=26,VIA=16,VIADESCRIPTION=17,WHSE=13,WRITER=14,XTE=40"
LogOnAsUser=INTEGER|1
Name=STRING|"SAMPLE"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action10=FOLDER
Action11=FOLDER
Action12=FOLDER
Action13=FOLDER
Action14=FOLDER
Action15=FOLDER
Action16=FOLDER
Action17=FOLDER
Action18=FOLDER
Action19=FOLDER
Action2=FOLDER
Action20=FOLDER
Action21=FOLDER
Action22=FOLDER
Action23=FOLDER
Action24=FOLDER
Action25=FOLDER
Action26=FOLDER
Action27=FOLDER
Action28=FOLDER
Action29=FOLDER
Action3=FOLDER
Action30=FOLDER
Action31=FOLDER
Action32=FOLDER
Action33=FOLDER
Action34=FOLDER
Action35=FOLDER
Action36=FOLDER
Action37=FOLDER
Action38=FOLDER
Action39=FOLDER
Action4=FOLDER
Action40=FOLDER
Action41=FOLDER
Action42=FOLDER
Action43=FOLDER
Action44=FOLDER
Action45=FOLDER
Action46=FOLDER
Action47=FOLDER
Action48=FOLDER
Action49=FOLDER
Action5=FOLDER
Action50=FOLDER
Action51=FOLDER
Action52=FOLDER
Action53=FOLDER
Action54=FOLDER
Action55=FOLDER
Action56=FOLDER
Action57=FOLDER
Action58=FOLDER
Action59=FOLDER
Action6=FOLDER
Action60=FOLDER
Action61=FOLDER
Action62=FOLDER
Action63=FOLDER
Action64=FOLDER
Action65=FOLDER
Action66=FOLDER
Action67=FOLDER
Action68=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER
[Actions\Action1]
ActionID=STRING|"A_LOOP_FILE"
Enabled=INTEGER|-1
Name=STRING|"File Loop"
Params=FOLDER
[Actions\Action1\Params]
createmode=STRING|"1"
date1=STRING|"20150406"
date2=STRING|"20150406"
destvar=STRING|"BODYTEXT"
DuringDays=STRING|"1"
DuringHours=STRING|"1"
DuringMinutes=STRING|"1"
DuringMonths=STRING|"1"
file0=STRING|"C:\sendfile\*.txt"
filecount=STRING|"1"
OlderDays=STRING|"1"
OlderHours=STRING|"1"
OlderMinutes=STRING|"1"
OlderMonths=STRING|"1"
savesize=STRING|"0"
searchkind=STRING|"0"
sort=STRING|"1"
sortby=STRING|"0"
sortorder=STRING|"0"
subdirs=STRING|"0"
timesize=STRING|"0"
WithoutPath=STRING|"0"
[Actions\Action10]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action10\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"8"
variable=STRING|"SHIP2ADDRESS4"
[Actions\Action11]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action11\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"9"
variable=STRING|"INVOICEDATE"
[Actions\Action12]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action12\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"10"
variable=STRING|"FUTURE"
[Actions\Action13]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action13\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"11"
variable=STRING|"DATESHIP"
[Actions\Action14]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action14\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"12"
variable=STRING|"CUSTPO"
[Actions\Action15]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action15\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"13"
variable=STRING|"WHSE"
[Actions\Action16]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action16\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"14"
variable=STRING|"WRITER"
[Actions\Action17]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action17\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"15"
variable=STRING|"CONTACT"
[Actions\Action18]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action18\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"16"
variable=STRING|"VIA"
[Actions\Action19]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action19\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"17"
variable=STRING|"VIADESCRIPTION"
[Actions\Action2]
ActionID=STRING|"A_FILE_WAIT"
Enabled=INTEGER|-1
Name=STRING|"Waiting {BodyText} file for 60 sec"
Params=FOLDER
[Actions\Action2\Params]
filename=STRING|"{BodyText}"
timeout=STRING|"60"
[Actions\Action20]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action20\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"18"
variable=STRING|"FOB"
[Actions\Action21]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action21\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"19"
variable=STRING|"INSTRUCTIONS"
[Actions\Action22]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action22\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"20"
variable=STRING|"SCPERCENT"
[Actions\Action23]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action23\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"21"
variable=STRING|"SALESMEN"
[Actions\Action24]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action24\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"22"
variable=STRING|"TERMS"
[Actions\Action25]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action25\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"23"
variable=STRING|"TERMDESC"
[Actions\Action26]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action26\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"24"
variable=STRING|"TERMPERCENT"
[Actions\Action27]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action27\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"25"
variable=STRING|"TERMDATE"
[Actions\Action28]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action28\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"26"
variable=STRING|"VENDOR"
[Actions\Action29]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action29\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"27"
variable=STRING|"PRODUCT"
[Actions\Action3]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action3\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"1"
variable=STRING|"EMAIL"
[Actions\Action30]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action30\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"28"
variable=STRING|"COMMENT"
[Actions\Action31]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action31\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"29"
variable=STRING|"PER"
[Actions\Action32]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action32\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"30"
variable=STRING|"PRCDE"
[Actions\Action33]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action33\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"31"
variable=STRING|"NETPRICE"
[Actions\Action34]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action34\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"32"
variable=STRING|"RESERVED1"
[Actions\Action35]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action35\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"33"
variable=STRING|"LISTPRICE"
[Actions\Action36]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action36\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"34"
variable=STRING|"COST"
[Actions\Action37]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action37\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"35"
variable=STRING|"ONORDER"
[Actions\Action38]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action38\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"36"
variable=STRING|"ONBO"
[Actions\Action39]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action39\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"37"
variable=STRING|"TOPICK"
[Actions\Action4]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action4\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"2"
variable=STRING|"ACCOUNTNUMBER"
[Actions\Action40]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action40\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"37"
variable=STRING|"ONPICK"
[Actions\Action41]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action41\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"38"
variable=STRING|"TOBO"
[Actions\Action42]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action42\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"39"
variable=STRING|"ONPICK"
[Actions\Action43]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action43\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"40"
variable=STRING|"XTE"
[Actions\Action44]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action44\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"41"
variable=STRING|"NUMOFITEMS"
[Actions\Action45]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action45\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"42"
variable=STRING|"BIDVALUE"
[Actions\Action46]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action46\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"43"
variable=STRING|"BIDCOST"
[Actions\Action47]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action47\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"44"
variable=STRING|"INVDATE"
[Actions\Action48]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action48\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"45"
variable=STRING|"FUTUREDATE"
[Actions\Action49]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action49\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"46"
variable=STRING|"DATESHIPPED"
[Actions\Action5]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action5\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"3"
variable=STRING|"SUFFIX"
[Actions\Action50]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action50\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"47"
variable=STRING|"TAXCDE"
[Actions\Action51]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action51\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"48"
variable=STRING|"TAXABLE"
[Actions\Action52]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action52\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"49"
variable=STRING|"EXEMPT"
[Actions\Action53]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action53\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"50"
variable=STRING|"TAXRATE"
[Actions\Action54]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action54\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"51"
variable=STRING|"TAXAMT"
[Actions\Action55]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action55\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"51"
variable=STRING|"INVOICENUMBER"
[Actions\Action56]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action56\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"53"
variable=STRING|"FREIGHT"
[Actions\Action57]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action57\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"54"
variable=STRING|"HANDLING"
[Actions\Action58]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action58\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"55"
variable=STRING|"CUSTOMERNAME"
[Actions\Action59]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action59\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"56"
variable=STRING|"CUSTOMERADDR1"
[Actions\Action6]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action6\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"4"
variable=STRING|"SHIPTONAME"
[Actions\Action60]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action60\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"57"
variable=STRING|"CUSTOMERADDR2"
[Actions\Action61]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action61\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"58"
variable=STRING|"CUSTOMERADDR3"
[Actions\Action62]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action62\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"59"
variable=STRING|"CONTACT"
[Actions\Action63]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action63\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"60"
variable=STRING|"PHONE"
[Actions\Action64]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action64\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"61"
variable=STRING|"FAX"
[Actions\Action65]
ActionID=STRING|"A_INET_SENDMAIL"
Enabled=INTEGER|-1
Name=STRING|"Send Email"
Params=FOLDER
[Actions\Action65\Params]
attachcount=STRING|"0"
auth=STRING|"1"
charset=STRING|"iso-8859-1"
from=STRING|"noreply@turnkeyips.com"
host=STRING|"smtp.gmail.com"
html=STRING|"1"
msg0=STRING|"<title></title>"
msg1=STRING|"<h2 style=""text-align: right;""><img alt="""" src=""http://www.turnkeyips.com/images/turnkey_ips_logo.png"" style=""width: 218px; height: 138px; float: left;"" />Turnkey Industrial<br />"
msg10=STRING|" "
msg11=STRING|"Invoice Number: {INVOICENUMBER}</p>"
msg13=STRING|"<table border=""1"" width=""100%"" height=""18"">"
msg14=STRING|" <tr>"
msg15=STRING|" <td width=""50%"" height=""12""><strong>Sold to:</strong> {ACCOUNTNUMBER}<br>"
msg16=STRING|" {<b>CUSTOMERNAME}<br>"
msg17=STRING|" </b>{CUSTOMERADDR1}<br>"
msg18=STRING|" {CUSTOMERADDR2}<br>"
msg19=STRING|" {CUSTOMERADDR3} <br />"
msg2=STRING|"13249 Barton Cir<br />"
msg20=STRING|" E-Mail:{EMAIL}<br />"
msg21=STRING|" Ph. {PHONE} Fx. {FAX}"
msg22=STRING|" <p> </p>"
msg23=STRING|" <p> </td>"
msg24=STRING|" <td width=""50%"" height=""12""><b>Ship to:<br>"
msg25=STRING|" </b><b>{SHIPTONAME}<br>"
msg26=STRING|" </b>{SHIPTOADDRESS1}<b><br>"
msg27=STRING|" </b>{SHIPTOADDRESS2}<b><br>"
msg28=STRING|" </b>{SHIPTOADDRESS3}"
msg29=STRING|" <p> </p>"
msg3=STRING|"Whittier, CA 90605<br />"
msg30=STRING|" <p> </p>"
msg31=STRING|" <p> </td>"
msg32=STRING|" </tr>"
msg33=STRING|"</table>"
msg36=STRING|"{EMAIL}"
msg37=STRING|"{ACCOUNTNUMBER}"
msg38=STRING|"{SUFFIX}"
msg39=STRING|"{SHIPTONAME}"
msg4=STRING|"Ph. 562.944.6994<br />"
msg40=STRING|"{SHIP2ADDRESS1}"
msg41=STRING|"{SHIP2ADDRESS2}"
msg42=STRING|"{SHIP2ADDRESS3}"
msg43=STRING|"{SHIP2ADDRESS4}"
msg44=STRING|"{INVOICEDATE}"
msg45=STRING|"{FUTURE}"
msg46=STRING|"{DATESHIP}"
msg47=STRING|"{CUSTPO}"
msg48=STRING|"{WHSE}"
msg49=STRING|"{WRITER}"
msg5=STRING|" </h2>"
msg50=STRING|"{CONTACT}"
msg51=STRING|"{VIA}"
msg52=STRING|"{VIADESCRIPTION}"
msg53=STRING|"{FOB}"
msg54=STRING|"{INSTRUCTIONS}"
msg55=STRING|"{SCPERCENT}"
msg56=STRING|"{SALESMEN}"
msg57=STRING|"{TERMS}"
msg58=STRING|"{TERMDESC}"
msg59=STRING|"{TERMPERCENT}"
msg60=STRING|"{TERMDATE}"
msg61=STRING|"{VENDOR}"
msg62=STRING|"{PRODUCT}"
msg63=STRING|"{COMMENT}"
msg64=STRING|"{PER}"
msg65=STRING|"{PRCDE}"
msg66=STRING|"{NETPRICE}"
msg67=STRING|"{RESERVED1}"
msg68=STRING|"{LISTPRICE}"
msg69=STRING|"{COST}"
msg7=STRING|"<h2 style=""text-align: center;""><span style=""font-size:36px;""><strong>I</strong><span style=""color:#000000;""><strong>NVOICE</strong></span></span></h2>"
msg70=STRING|"{ONORDER}"
msg71=STRING|"{TOPICK}"
msg72=STRING|"{ONBO}"
msg73=STRING|"{TOBO}"
msg74=STRING|"{ONPICK}"
msg75=STRING|"{XTE}"
msg76=STRING|"{NUMOFITEMS}"
msg77=STRING|"{BIDVALUE}"
msg78=STRING|"{BIDCOST}"
msg79=STRING|"{INVDATE}"
msg80=STRING|"{FUTUREDATE}"
msg81=STRING|"{DATESHIPPED}"
msg82=STRING|"{TAXCDE}"
msg83=STRING|"{TAXABLE}"
msg84=STRING|"{EXEMPT}"
msg85=STRING|"{TAXRATE}"
msg86=STRING|"{TAXAMT}"
msg87=STRING|"{RESERVED2}"
msg88=STRING|"{FREIGHT}"
msg89=STRING|"{HANDLING}"
msg9=STRING|"<p style=""text-align: center;"">Date Ordered: {INVOICEDATE} "
msg90=STRING|"{CUSTOMERNAME}"
msg91=STRING|"{CUSTOMERADDR1}"
msg92=STRING|"{CUSTOMERADDR2}"
msg93=STRING|"{CUSTOMERADDR3}"
msg94=STRING|"{CONTACT}"
msg95=STRING|"{PHONE}"
msg96=STRING|"{FAX}"
msg97=STRING|"{INVOICENUMBER}"
msgcount=STRING|"98"
password=STRING|"3897725250267324286239089"
passwordmode=STRING|"0"
port=STRING|"587"
SSL=STRING|"2"
subject=STRING|"Invoice{ExtractFileNameNoExt({BodyText})} | received today | {DateTime}"
to=STRING|"{email}"
user=STRING|"tipsinvoicing@gmail.com"
[Actions\Action66]
ActionID=STRING|"A_FILE_TEXTWRITE"
Enabled=INTEGER|-1
Name=STRING|"Create text file C:\sentfile\sentlog.txt"
Params=FOLDER
[Actions\Action66\Params]
encode=STRING|"0"
fileexists=STRING|"1"
filname=STRING|"C:\sentfile\sentlog.txt"
line0=STRING|"{ExtractFileNameNoExt({BodyText})} {DateTime} to {email} Sucessfull"
linecount=STRING|"1"
suppress=STRING|"0"
[Actions\Action67]
ActionID=STRING|"A_FILE_COPY"
Enabled=INTEGER|-1
Name=STRING|"Copy/Move File"
Params=FOLDER
[Actions\Action67\Params]
destdir=STRING|"C:\sentfile\"
f_count=STRING|"2"
file0=STRING|"{BodyText}"
hidden=STRING|"1"
ifexists=STRING|"0"
move=STRING|"1"
rename=STRING|"0"
renamemask=STRING|"*.*.new"
subdir=STRING|"0"
system=STRING|"1"
[Actions\Action68]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action7]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action7\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"5"
variable=STRING|"SHIP2ADDRESS1"
[Actions\Action8]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action8\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"6"
variable=STRING|"SHIP2ADDRESS2"
[Actions\Action9]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action9\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"7"
variable=STRING|"SHIP2ADDRESS3"
[Events]
Event1=FOLDER
[Events\Event1]
Enabled=INTEGER|0
EventID=STRING|"E_FILE_MONITOR"
Params=FOLDER
UnigueID=INTEGER|674526919
[Events\Event1\Params]
chg=STRING|"1"
chga=STRING|"1"
chgsl=STRING|"1"
chgsm=STRING|"1"
chgtl=STRING|"1"
chgtm=STRING|"1"
del=STRING|"1"
folder1=STRING|"c:\sendfile\"
foldercount=STRING|"1"
incmask=STRING|"*.txt"
interval=STRING|"60"
listmode=STRING|"1"
mon_files=STRING|"1"
mon_folders=STRING|"0"
new=STRING|"1"
pass=STRING|"0"
passmode=STRING|"1"
saveresults=STRING|"0"
subfolders1=STRING|"0"Re: Text extraction of a delimited file
You can use indexed variables in the loop (item1, item2, ... and so on)
Look at my example. It demonstrates how to parse the line #27 in your text.
Look at my example. It demonstrates how to parse the line #27 in your text.
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|317955339
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task15"
Hide=INTEGER|0
ID=INTEGER|425319230
LogOnAsUser=INTEGER|1
Name=STRING|"How to parse line27"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action10=FOLDER
Action11=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER
[Actions\Action1]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""TXT"" with value ""MYEMAILNAME@yahoo.com{EOL}1070{EOL}ST SUFFIX{EOL}S..."""
Params=FOLDER
[Actions\Action1\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"TXT"
varvalue=STRING|"MYEMAILNAME@yahoo.com{EOL}1070{EOL}ST SUFFIX{EOL}SHIP2NAME{EOL}SHIP2ADDRESS1{EOL}SHIP2ADDRESS2{EOL}SHIP2ADDRESS3{EOL}SHIP2ADDRESS4{EOL}17251{EOL}17252{EOL}17252{EOL}37838{EOL}1{EOL}RRM{EOL}JOSE GUZMAN{EOL}OT{EOL}OUR TRUCK{EOL}02{EOL}PJ03/31{EOL}SC%{EOL}RM{EOL}N30{EOL}NET 30 DAYS{EOL}TERM%{EOL}17293{EOL}VENDOR#{EOL}63985*1y63986*1y63987*1yCy57149*1y63989*1y23425*1{EOL}1/2 X 30'UHF SEALANT ENTERTECHy1/4 X 50'UHF SEALANT ENTERTECHy3/8 X 50'UHF SEALANT ENTERTECHyyy21/2 COOPLOK STD ""E"" GSKT ONLY{EOL}1y1y1yy1y1y1{EOL}MU35yMU35yMU35yyMU50yMU50yMU40{EOL}193349y108507y193349yy3515y4061y7634{EOL}yyyy1yy1{EOL}250000y155650y250000yy10750y12980y10200{EOL}125000y70150y125000yy1740y2012y4550{EOL}1y1y1yy10y10y10{EOL}1y1y1yy10y10y10{EOL}1y1y1yy10y10y10{EOL}0y0y0yy0y0y0{EOL}1y1y1yy10y10y10{EOL}TyTyTyTyTyTyT{EOL}7{EOL}64731{EOL}40317{EOL}17263{EOL}17263{EOL}17256{EOL}MRD{EOL}TAXED?{EOL}TAXNUMBER{EOL}4813{EOL}RESERVED{EOL}RESERVED{EOL}7373{EOL}174363{EOL}MY COMPANY NAME{EOL}16195 STEPHANS STREET{EOL}CITY OF INDUSTRY, AZ 91745{EOL}RESERVED{EOL}JOSE GUZMAN{EOL}555-1234{EOL}555-1233"
[Actions\Action10]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action11]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""Item count = {cnt}"""
Params=FOLDER
[Actions\Action11\Params]
icon=STRING|"1"
msg0=STRING|"Item count = {cnt}"
msg1=STRING|"Line #27 = {line27}"
msg2=STRING|"{addon}"
msgcount=STRING|"3"
playsound=STRING|"0"
showmessage=STRING|"1"
[Actions\Action2]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action2\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"41"
variable=STRING|"cnt"
[Actions\Action3]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action3\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"27"
variable=STRING|"line27"
[Actions\Action4]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Delimit Variable"
Params=FOLDER
[Actions\Action4\Params]
colon=STRING|"0"
comma=STRING|"0"
other=STRING|"1"
otherchar=STRING|"*"
quote=STRING|"0"
semocolon=STRING|"0"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{line27}"
tab=STRING|"0"
variable=STRING|"tmp"
[Actions\Action5]
ActionID=STRING|"A_TXT_COOMATEXT"
Enabled=INTEGER|-1
Name=STRING|"Comma-separated string -> text"
Params=FOLDER
[Actions\Action5\Params]
kind=STRING|"0"
line00000000=STRING|"{tmp}"
lines=STRING|"1"
variable=STRING|"tmp"
[Actions\Action6]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""ADDON"" with value """""
Params=FOLDER
[Actions\Action6\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"ADDON"
[Actions\Action7]
ActionID=STRING|"A_LOOP_SIMPLE"
Enabled=INTEGER|-1
Name=STRING|"Simple Loop"
Params=FOLDER
[Actions\Action7\Params]
begin=STRING|"1"
end=STRING|"{cnt}"
variable=STRING|"NUM"
[Actions\Action8]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action8\Params]
external=STRING|"0"
line00000000=STRING|"{tmp}"
linecount=STRING|"1"
linenum=STRING|"{num}"
variable=STRING|"item{num}"
[Actions\Action9]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""ADDON"" with value ""{addon}{EOL}item{num} = {item{num}}"""
Params=FOLDER
[Actions\Action9\Params]
expand=STRING|"1"
varname=STRING|"ADDON"
varvalue=STRING|"{addon}{EOL}item{num} = {item{num}}"
Oleg Yershov
Re: Text extraction of a delimited file
Look at the alternative version.
You can use standard comma-separated string as array: {MyVar(0)}, {MyVar(1)}, etc
or {MyVar({num})} if variable NUM contains a number
Read more here
You can use standard comma-separated string as array: {MyVar(0)}, {MyVar(1)}, etc
or {MyVar({num})} if variable NUM contains a number
Read more here
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|317955339
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task20"
Hide=INTEGER|0
ID=INTEGER|1282881489
LogOnAsUser=INTEGER|1
Name=STRING|"How to parse line27 (alternative version)"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action10=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER
[Actions\Action1]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""TXT"" with value ""MYEMAILNAME@yahoo.com{EOL}1070{EOL}ST SUFFIX{EOL}S..."""
Params=FOLDER
[Actions\Action1\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"TXT"
varvalue=STRING|"MYEMAILNAME@yahoo.com{EOL}1070{EOL}ST SUFFIX{EOL}SHIP2NAME{EOL}SHIP2ADDRESS1{EOL}SHIP2ADDRESS2{EOL}SHIP2ADDRESS3{EOL}SHIP2ADDRESS4{EOL}17251{EOL}17252{EOL}17252{EOL}37838{EOL}1{EOL}RRM{EOL}JOSE GUZMAN{EOL}OT{EOL}OUR TRUCK{EOL}02{EOL}PJ03/31{EOL}SC%{EOL}RM{EOL}N30{EOL}NET 30 DAYS{EOL}TERM%{EOL}17293{EOL}VENDOR#{EOL}63985*1y63986*1y63987*1yCy57149*1y63989*1y23425*1{EOL}1/2 X 30'UHF SEALANT ENTERTECHy1/4 X 50'UHF SEALANT ENTERTECHy3/8 X 50'UHF SEALANT ENTERTECHyyy21/2 COOPLOK STD ""E"" GSKT ONLY{EOL}1y1y1yy1y1y1{EOL}MU35yMU35yMU35yyMU50yMU50yMU40{EOL}193349y108507y193349yy3515y4061y7634{EOL}yyyy1yy1{EOL}250000y155650y250000yy10750y12980y10200{EOL}125000y70150y125000yy1740y2012y4550{EOL}1y1y1yy10y10y10{EOL}1y1y1yy10y10y10{EOL}1y1y1yy10y10y10{EOL}0y0y0yy0y0y0{EOL}1y1y1yy10y10y10{EOL}TyTyTyTyTyTyT{EOL}7{EOL}64731{EOL}40317{EOL}17263{EOL}17263{EOL}17256{EOL}MRD{EOL}TAXED?{EOL}TAXNUMBER{EOL}4813{EOL}RESERVED{EOL}RESERVED{EOL}7373{EOL}174363{EOL}MY COMPANY NAME{EOL}16195 STEPHANS STREET{EOL}CITY OF INDUSTRY, AZ 91745{EOL}RESERVED{EOL}JOSE GUZMAN{EOL}555-1234{EOL}555-1233"
[Actions\Action10]
ActionID=STRING|"A_DIALOG_MESSAGE"
Enabled=INTEGER|-1
Name=STRING|"Show ""Item count = {cnt}"""
Params=FOLDER
[Actions\Action10\Params]
icon=STRING|"1"
msg0=STRING|"Item count = {cnt}"
msg1=STRING|"Line #27 = {line27}"
msg2=STRING|"{addon}"
msgcount=STRING|"3"
playsound=STRING|"0"
showmessage=STRING|"1"
[Actions\Action2]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action2\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"41"
variable=STRING|"cnt"
[Actions\Action3]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action3\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"27"
variable=STRING|"line27"
[Actions\Action4]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Delimit Variable"
Params=FOLDER
[Actions\Action4\Params]
colon=STRING|"0"
comma=STRING|"0"
other=STRING|"1"
otherchar=STRING|"*"
quote=STRING|"0"
semocolon=STRING|"0"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{line27}"
tab=STRING|"0"
variable=STRING|"tmp"
[Actions\Action5]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""ADDON"" with value """""
Params=FOLDER
[Actions\Action5\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"ADDON"
[Actions\Action6]
ActionID=STRING|"A_LOOP_SIMPLE"
Enabled=INTEGER|-1
Name=STRING|"Simple Loop"
Params=FOLDER
[Actions\Action6\Params]
begin=STRING|"1"
end=STRING|"{cnt}"
variable=STRING|"NUM"
[Actions\Action7]
ActionID=STRING|"A_VARIABLES_INCREMENT"
Enabled=INTEGER|-1
Name=STRING|"Increment variable ""num"""
Params=FOLDER
[Actions\Action7\Params]
incement=STRING|"-1"
vaiable=STRING|"num"
[Actions\Action8]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""ADDON"" with value ""{addon}{EOL}item{num} = {tmp({num})}"""
Params=FOLDER
[Actions\Action8\Params]
expand=STRING|"1"
varname=STRING|"ADDON"
varvalue=STRING|"{addon}{EOL}item{num} = {tmp({num})}"
[Actions\Action9]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
Oleg Yershov
Re: Text extraction of a delimited file
Hello,
I really appreciate your help!!!
I used your example(s) and seem to be getting an error message, after I changed the text to read from the c:\sendfiles that I just cant figure out. My send file c:\sendfile will have multiple records in it. I also reformatted our export file to export it comma delimited file.
* also if I format an email invoice from this record how do list the products, qty ordered, price etc. for multiple items?
* is there a way to create and pdf file from the data that is read into the email?
Thanks again for your help!!!!!!!
Your the best!!
I: 4/12/2015 5:51:01 PM: Executing "8.Simple Loop"
E: 4/12/2015 5:51:01 PM: '''' is not a valid integer value
E: 4/12/2015 5:51:01 PM: An error occurred. Step #8 (Simple Loop).
E: 4/12/2015 5:51:01 PM: Task execution is aborted
******* one Invoice in the c:\sendfile *******
I really appreciate your help!!!
I used your example(s) and seem to be getting an error message, after I changed the text to read from the c:\sendfiles that I just cant figure out. My send file c:\sendfile will have multiple records in it. I also reformatted our export file to export it comma delimited file.
* also if I format an email invoice from this record how do list the products, qty ordered, price etc. for multiple items?
* is there a way to create and pdf file from the data that is read into the email?
Thanks again for your help!!!!!!!
Your the best!!
I: 4/12/2015 5:51:01 PM: Executing "8.Simple Loop"
E: 4/12/2015 5:51:01 PM: '''' is not a valid integer value
E: 4/12/2015 5:51:01 PM: An error occurred. Step #8 (Simple Loop).
E: 4/12/2015 5:51:01 PM: Task execution is aborted
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|726124785
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task22"
Hide=INTEGER|0
ID=INTEGER|1969860690
LogOnAsUser=INTEGER|1
Name=STRING|"Copy of How to parse line27"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action10=FOLDER
Action11=FOLDER
Action12=FOLDER
Action13=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER
[Actions\Action1]
ActionID=STRING|"A_LOOP_FILE"
Enabled=INTEGER|-1
Name=STRING|"File Loop"
Params=FOLDER
[Actions\Action1\Params]
createmode=STRING|"1"
date1=STRING|"20150412"
date2=STRING|"20150412"
destvar=STRING|"BODYTEXT"
DuringDays=STRING|"1"
DuringHours=STRING|"1"
DuringMinutes=STRING|"1"
DuringMonths=STRING|"1"
file0=STRING|"C:\sendfile\*.txt"
filecount=STRING|"1"
OlderDays=STRING|"1"
OlderHours=STRING|"1"
OlderMinutes=STRING|"1"
OlderMonths=STRING|"1"
savesize=STRING|"0"
searchkind=STRING|"0"
sort=STRING|"1"
sortby=STRING|"0"
sortorder=STRING|"0"
subdirs=STRING|"1"
timesize=STRING|"0"
WithoutPath=STRING|"0"
[Actions\Action10]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""ADDON"" with value ""{addon}{EOL}item{num} = {tmp({num})}"""
Params=FOLDER
[Actions\Action10\Params]
expand=STRING|"1"
varname=STRING|"ADDON"
varvalue=STRING|"{addon}{EOL}item{num} = {tmp({num})}"
[Actions\Action11]
ActionID=STRING|"A_INET_SENDMAIL"
Enabled=INTEGER|-1
Name=STRING|"Send Email"
Params=FOLDER
[Actions\Action11\Params]
attachcount=STRING|"0"
auth=STRING|"1"
charset=STRING|"iso-8859-1"
from=STRING|"noreply@txxxnkeyips.com"
host=STRING|"smtp.gmail.com"
html=STRING|"1"
msg0=STRING|"<html>"
msg1=STRING|"<head>"
msg11=STRING|"<h2 style=""text-align: center;""><strong>INVOICE</strong></h2>"
msg12=STRING|"</body>"
msg13=STRING|"</html>"
msg14=STRING|"</p>"
msg17=STRING|"{TextFile({BodyText})}"
msg2=STRING|"<title></title>"
msg3=STRING|"</head>"
msg4=STRING|"<body>"
msg5=STRING|"<h2 style=""text-align: right;""><img alt="""" src=""http://www.xxxnkeyips.com/images/XXXnkey_ips_logo.png"" style=""width: 218px; height: 138px; float: left;"" />XXXnkey Industrial<br />"
msg6=STRING|"13249 Karton Cir<br />"
msg7=STRING|"Whittier, CA 90605<br />"
msg8=STRING|"Ph. 555.944.6994<br />"
msg9=STRING|" </h2>"
msgcount=STRING|"18"
password=STRING|"38977252539089"
passwordmode=STRING|"0"
port=STRING|"587"
SSL=STRING|"2"
subject=STRING|"Invoice {ExtractFileNameNoExt({BodyText})} | received today | {DateTime}"
to=STRING|"{email}"
user=STRING|"xxnvoicing@gmail.com"
[Actions\Action12]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action13]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action2]
ActionID=STRING|"A_FILE_WAIT"
Enabled=INTEGER|-1
Name=STRING|"Waiting {BodyText} file for 60 sec"
Params=FOLDER
[Actions\Action2\Params]
filename=STRING|"{BodyText}"
timeout=STRING|"60"
[Actions\Action3]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action3\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"1"
variable=STRING|"email"
[Actions\Action4]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action4\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"26"
variable=STRING|"cnt"
[Actions\Action5]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action5\Params]
external=STRING|"0"
line00000000=STRING|"{txt}"
linecount=STRING|"1"
linenum=STRING|"27"
variable=STRING|"line27"
[Actions\Action6]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Delimit Variable"
Params=FOLDER
[Actions\Action6\Params]
colon=STRING|"0"
comma=STRING|"1"
other=STRING|"0"
otherchar=STRING|"*"
quote=STRING|"0"
semocolon=STRING|"0"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{line27}"
tab=STRING|"0"
variable=STRING|"tmp"
[Actions\Action7]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""ADDON"" with value """""
Params=FOLDER
[Actions\Action7\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"ADDON"
[Actions\Action8]
ActionID=STRING|"A_LOOP_SIMPLE"
Enabled=INTEGER|-1
Name=STRING|"Simple Loop"
Params=FOLDER
[Actions\Action8\Params]
begin=STRING|"1"
end=STRING|"{cnt}"
variable=STRING|"NUM"
[Actions\Action9]
ActionID=STRING|"A_VARIABLES_INCREMENT"
Enabled=INTEGER|-1
Name=STRING|"Increment variable ""num"""
Params=FOLDER
[Actions\Action9\Params]
incement=STRING|"-1"
vaiable=STRING|"num"******* one Invoice in the c:\sendfile *******
Code: Select all
noreply@xxxinvoicing@gmail.com
1070
LANGER KITE COMPANY INC
16195 STEPHANS STREET
CITY OF INDUSTRY, AZ 91555
JOSE
555-336-3100
555-369-9328
03/25/15
03/26/15
03/26/15
37838
1
RRM
JOSE
OT
OUR TRUCK
02
PJ03/31
SC%
RM
N30
NET 30 DAYS
TERM%
05/06/15
VENDOR#
63985*1,63986*1,63987*1,0000*1,57149*1,63989*1,23425*1,
1/2 X 30' UHF INERTECH SEALANT,1/4 X 50' UHF INERTECH SEALANT,3/8 X 50' UHF INERTECH SEALANT,xxxxxxx,2 COOPLOK STD "E" GASKET ONLY,21/2 COOPLOK STD "E" GSKT ONLY,2 DIXON SANI HEX HGR #B24PS,,
1,1,1,1,1,1,1,
MU35,MU35,MU35,MU00,MU50,MU50,MU40,
193349,108507,193349,0,3515,4061,7634,
,,,,1,,1,
250000,155650,250000,0,10750,12980,10200,
125000,70150,125000,0,1740,2012,4550,
1,1,1,0,10,10,10,
1,1,1,0,10,10,10,
1,1,1,0,10,10,10,
0,0,0,0,0,0,0,
1,1,1,,10,10,10,
T,T,T,T,T,T,T,
7
64731
40317
04/06/15
04/06/15
03/30/15
MRD
TAXED?
TAXNUMBER
4813
999999
174363Re: Text extraction of a delimited file
You corrected the step #3 (external file {BodyText})
Look at the steps #4 and #5
Why did you not correct them?
Variable TXT is empty now. So you get empty vaiables CNT and LINE27
Look at the step #11 (send email). I think that you should move it out of the simple loop (move it before step #13)
Look at the steps #4 and #5
Why did you not correct them?
Variable TXT is empty now. So you get empty vaiables CNT and LINE27
Look at the step #11 (send email). I think that you should move it out of the simple loop (move it before step #13)
Oleg Yershov
Re: Text extraction of a delimited file
Thanks I corrected 4 and 5 and moved the send email, still getting an error?
I: 4/13/2015 7:17:40 AM: Executing "8.Simple Loop"
E: 4/13/2015 7:17:40 AM: '''' is not a valid integer value
E: 4/13/2015 7:17:40 AM: An error occurred. Step #8 (Simple Loop).
E: 4/13/2015 7:17:40 AM: Task execution is aborted
I: 4/13/2015 7:17:40 AM: Executing "8.Simple Loop"
E: 4/13/2015 7:17:40 AM: '''' is not a valid integer value
E: 4/13/2015 7:17:40 AM: An error occurred. Step #8 (Simple Loop).
E: 4/13/2015 7:17:40 AM: Task execution is aborted
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|726124785
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task22"
Hide=INTEGER|0
ID=INTEGER|1969860690
LogOnAsUser=INTEGER|1
Name=STRING|"Copy of How to parse line27"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action10=FOLDER
Action11=FOLDER
Action12=FOLDER
Action13=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
Action5=FOLDER
Action6=FOLDER
Action7=FOLDER
Action8=FOLDER
Action9=FOLDER
[Actions\Action1]
ActionID=STRING|"A_LOOP_FILE"
Enabled=INTEGER|-1
Name=STRING|"File Loop"
Params=FOLDER
[Actions\Action1\Params]
createmode=STRING|"1"
date1=STRING|"20150412"
date2=STRING|"20150412"
destvar=STRING|"BODYTEXT"
DuringDays=STRING|"1"
DuringHours=STRING|"1"
DuringMinutes=STRING|"1"
DuringMonths=STRING|"1"
file0=STRING|"C:\sendfile\*.txt"
filecount=STRING|"1"
OlderDays=STRING|"1"
OlderHours=STRING|"1"
OlderMinutes=STRING|"1"
OlderMonths=STRING|"1"
savesize=STRING|"0"
searchkind=STRING|"0"
sort=STRING|"1"
sortby=STRING|"0"
sortorder=STRING|"0"
subdirs=STRING|"1"
timesize=STRING|"0"
WithoutPath=STRING|"0"
[Actions\Action10]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""ADDON"" with value ""{addon}{EOL}item{num} = {tmp({num})}"""
Params=FOLDER
[Actions\Action10\Params]
expand=STRING|"1"
varname=STRING|"ADDON"
varvalue=STRING|"{addon}{EOL}item{num} = {tmp({num})}"
[Actions\Action11]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action12]
ActionID=STRING|"A_INET_SENDMAIL"
Enabled=INTEGER|-1
Name=STRING|"Send Email"
Params=FOLDER
[Actions\Action12\Params]
attachcount=STRING|"0"
auth=STRING|"1"
charset=STRING|"iso-8859-1"
from=STRING|"noreply@tnkeyips.com"
host=STRING|"smtp.gmail.com"
html=STRING|"1"
msg0=STRING|"<html>"
msg1=STRING|"<head>"
msg11=STRING|"<h2 style=""text-align: center;""><strong>INVOICE</strong></h2>"
msg12=STRING|"</body>"
msg13=STRING|"</html>"
msg14=STRING|"</p>"
msg17=STRING|"{TextFile({BodyText})}"
msg2=STRING|"<title></title>"
msg3=STRING|"</head>"
msg4=STRING|"<body>"
msg5=STRING|"<h2 style=""text-align: right;""><img alt="""" src=""http://www.kkeyips.com/images/kkurnkey_ips_logo.png"" style=""width: 218px; height: 138px; float: left;"" />Kurnkey Industrial<br />"
msg6=STRING|"13249 Karton Cir<br />"
msg7=STRING|"Palm, CA 90705<br />"
msg8=STRING|"Ph. 562.944.6994<br />"
msg9=STRING|" </h2>"
msgcount=STRING|"18"
password=STRING|"3897725224286239089"
passwordmode=STRING|"0"
port=STRING|"587"
SSL=STRING|"2"
subject=STRING|"Invoice {ExtractFileNameNoExt({BodyText})} | received today | {DateTime}"
to=STRING|"{email}"
user=STRING|"tipsinvoicing@gmail.com"
[Actions\Action13]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"
[Actions\Action2]
ActionID=STRING|"A_FILE_WAIT"
Enabled=INTEGER|-1
Name=STRING|"Waiting {BodyText} file for 60 sec"
Params=FOLDER
[Actions\Action2\Params]
filename=STRING|"{BodyText}"
timeout=STRING|"60"
[Actions\Action3]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action3\Params]
external=STRING|"1"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"1"
variable=STRING|"email"
[Actions\Action4]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action4\Params]
external=STRING|"0"
filename=STRING|"{BodyText}"
linecount=STRING|"1"
linenum=STRING|"26"
variable=STRING|"cnt"
[Actions\Action5]
ActionID=STRING|"A_TXT_EXTRACTLINE"
Enabled=INTEGER|-1
Name=STRING|"TXT Extract Line"
Params=FOLDER
[Actions\Action5\Params]
external=STRING|"0"
filename=STRING|"{BodyText}"
linecount=STRING|"0"
linenum=STRING|"27"
variable=STRING|"line27"
[Actions\Action6]
ActionID=STRING|"A_VARIABLES_DELIMITED"
Enabled=INTEGER|-1
Name=STRING|"Delimit Variable"
Params=FOLDER
[Actions\Action6\Params]
colon=STRING|"0"
comma=STRING|"1"
other=STRING|"0"
otherchar=STRING|"*"
quote=STRING|"0"
semocolon=STRING|"0"
space=STRING|"0"
spaceasone=STRING|"0"
string=STRING|"{line27}"
tab=STRING|"0"
variable=STRING|"tmp"
[Actions\Action7]
ActionID=STRING|"A_VARIABLES_CREATE"
Enabled=INTEGER|-1
Name=STRING|"Create local variable ""ADDON"" with value """""
Params=FOLDER
[Actions\Action7\Params]
expand=STRING|"0"
varkind=STRING|"1"
varname=STRING|"ADDON"
[Actions\Action8]
ActionID=STRING|"A_LOOP_SIMPLE"
Enabled=INTEGER|-1
Name=STRING|"Simple Loop"
Params=FOLDER
[Actions\Action8\Params]
begin=STRING|"1"
end=STRING|"{cnt}"
variable=STRING|"NUM"
[Actions\Action9]
ActionID=STRING|"A_VARIABLES_INCREMENT"
Enabled=INTEGER|-1
Name=STRING|"Increment variable ""num"""
Params=FOLDER
[Actions\Action9\Params]
incement=STRING|"-1"
vaiable=STRING|"num"