MidStr Woe

[armsys]

Can some Macro Scheduler gurus enlighten me why MidStr doesn't get along with {pos(%tab%,%Item%)-1}?

Code: Select all

VBSTART
VBEND
VBEval>chr(9),tab
Let>Item=12345%tab%67890
Let>pos={pos(%tab%,%Item%)-1}
MDL>pos
MidStr>ItemCmd0_0,1,{pos(%tab%,%Item%)-1},result

[Marcus Tettmar]

It's the extra commas. Confuses the parser for MidStr.

Anyway, you don't need that VBScript. V12 has %TAB% built in.

So you can just do:

Let>Item=12345%tab%67890
Let>x={pos(%tab%,%Item%)-1}
MidStr>Item,1,x,result

Or even quicker:

Let>Item=12345%tab%67890
Let>result={Copy(%Item%,1,pos(%tab%,%Item%)-1)}

[Marcus Tettmar]

Or even:

Let>Item=12345%tab%67890
RegEx>^.*(?=\t),Item,0,results,numfound,0