Extract Portion of Text Not Surrounded by Tags

[z38601]

So I have code that looks like this:

<TR>
<TD class="formTableTdNoBorder" align="left">
<P>
<b>Expire Date: </b>
07-31-2020
<br>
</TD>
</TR>

The iMacros Browser generates the following TAG line to capture "Expire Date: 07-31-2020":

VERSION BUILD=11.5.497.9113
...
TAG POS=14 TYPE=P FORM=NAME:validateSelectForm ATTR=* EXTRACT=TXT

However, all I really want to extract is the date portion after "Expire Date:" How do I extract just the date when it's not in its own tag?

[chivracq]

So I have code that looks like this:

Code: Select all

<TR>
<TD class="formTableTdNoBorder" align="left">
    <P>
    <b>Expire Date: </b>
    07-31-2020
    <br>
</TD>
</TR>

The iMacros Browser generates the following TAG line to capture "Expire Date: 07-31-2020":

Code: Select all

    VERSION BUILD=11.5.497.9113
    ...
    TAG POS=14 TYPE=P FORM=NAME:validateSelectForm ATTR=* EXTRACT=TXT

However, all I really want to extract is the date portion after "Expire Date:" How do I extract just the date when it's not in its own tag?

FCI:

Code: Select all

iMB v11.5, Win7/8.x/10...(?)

Yep, then that's the purpose of using 'EVAL()' on your Extract to keep only the part that you want, stg like... (2 Solutions):

Code: Select all

TAG POS=14 TYPE=P FORM=NAME:validateSelectForm ATTR=* EXTRACT=TXT
SET Exp_Date_1 EVAL("var s='{{!EXTRACT}}'; var x,y,z; z=s.replace('Expire Date: ',''); z;")
SET Exp_Date_2 EVAL("var s='{{!EXTRACT}}'; var x,y,z; x=s.split(': '); y=x[1]; z=y.trim(); z;")
PROMPT EXTRACT:<SP>_{{!EXTRACT}}_<BR><BR>Exp_Date_1:<SP>_{{Exp_Date_1}}_<BR><BR>Exp_Date_2:<SP>_{{Exp_Date_2}}_

The 'trim()' in the 2nd Implementation is maybe not needed, I'm not sure how iMacros will treat the "<br>" in the Cell.

And in your case, as the "Expire Date: " part is in Bold and can be tagged directly, you can probably use 'Relative Positioning', with stg like...:

Code: Select all

TAG POS=1 TYPE=STRONG FORM=NAME:validateSelectForm ATTR=TXT:Expire<SP>Date:*
TAG POS=R1 TYPE=* ATTR=* EXTRACT=TXT
PROMPT EXTRACT:<SP>_{{!EXTRACT}}_

[z38601]

Thank you so much, chivracq, for your help on this. I was finally able to extract just the date using a modified version of your solution 1.

[chivracq]

Thank you so much, chivracq, for your help on this. I was finally able to extract just the date using a modified version of your solution 1.

OK, good to hear, and post your final Script with your "modified version", will be also useful for other Users...