Parsing Code Macro Trouble!

S

Snaybot

New Member
Joined
Apr 28, 2015
Messages
40
I have raw code export:

Cross Post:

http://www.msofficeforums.com/excel-programming/31160-parsing-code-macro-trouble.html
http://www.excelforum.com/showthread.php?t=1139253&p=4386328&highlight=#post4386328


STEP NAME="S0"
{
DESCRIPTION="Abort Logic"
RECTANGLE= { X=205 Y=60 H=40 W=120 }
}
STEP NAME="S10"
{
DESCRIPTION="Abort State Setup"
RECTANGLE= { X=205 Y=196 H=40 W=120 }
ACTION NAME="A1"
{
DESCRIPTION="Set unit message to message 10"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/P_MSG_PATH.CV' := '^/P_MSG_10';
'^/P_MSG_TYPE.CV' := 'MSG_TYPE:Failure'"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A2"
{
DESCRIPTION="Set Failure Devices Mask to 0"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/FAIL_MONITOR/DEV_FAIL_MASK.CV' := 0;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A3"
{
DESCRIPTION="Disable Process Failure Conditions "
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/FAIL_MONITOR/CND1/DISABLE.CV' := 1;
'^/FAIL_MONITOR/CND2/DISABLE.CV' := 1;
'^/FAIL_MONITOR/CND3/DISABLE.CV' := 1;
'^/FAIL_MONITOR/CND4/DISABLE.CV' := 1;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A4"
{
DESCRIPTION="If PH-ARB composite is active then set PH-ARB composite to stop"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '^/FAIL_MONITOR/PH-ARB/STATE.CV' = '$sfc_states:Sequence Active' THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A5"
{
DESCRIPTION="Send Sync message 254 to Destination Unit"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#THIS-UNIT#/U_SYNC_MSG_WR.CV' := 'SYNC_MSG:Phase Aborted';"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A6"
{
DESCRIPTION="Clear unit message 2"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/P_MSG_PATH2.CV' := """";
'^/P_MSG_TYPE2.CV' := 'MSG_TYPE:Information'"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
}
STEP NAME="S20"
{
DESCRIPTION="Set EM Abort State"
RECTANGLE= { X=205 Y=332 H=40 W=120 }
ACTION NAME="A1"
{
DESCRIPTION="Set #EM_INLET# to HOLD"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '//#EM_INLET#/OWNER_ID.CV' = '/THIS-UNIT' THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A2"
{
DESCRIPTION="Set #EM_PRESS# to HOLD"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '//#EM_PRESS#/OWNER_ID.CV' = '/THIS-UNIT' THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="TRUE"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A3"
{
DESCRIPTION="Set #EM_OUTLET# to HOLD"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '//#EM_OUTLET#/OWNER_ID.CV' = '/THIS-UNIT' THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="TRUE"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A4"
{
DESCRIPTION="Set #CM_OUTLET# to Close"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_OUTLET#/CAS_SP.CV' := 'VLV_SP:CLOSE';"
DELAY_TIME=0
CONFIRM_EXPRESSION="TRUE"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A5"
{
DESCRIPTION="Set #CM_LPT_DRN_VLV# to Close"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_LPT_DRN_VLV#/CAS_SP.CV' := 'VLV_SP:CLOSE';"
DELAY_TIME=0
CONFIRM_EXPRESSION="TRUE"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A6"
{
DESCRIPTION="Set #EM_AGIT# to HOLD"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '//#EM_AGIT#/OWNER_ID.CV' = '/THIS-UNIT'
THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A7"
{
DESCRIPTION="Set #EM_TEMP# to HOLD"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="IF '//#EM_TEMP#/OWNER_ID.CV' = '/THIS-UNIT'
THEN
ENDIF;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
}
STEP NAME="S30"
{
DESCRIPTION="Disable Alarms"
RECTANGLE= { X=200 Y=468 H=40 W=130 }
ACTION NAME="A1"
{
DESCRIPTION="Disable # CM_PRESS#/LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_PRESS#/LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A2"
{
DESCRIPTION="Disable # CM_PRESS#/LO_LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_PRESS#/LO_LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A3"
{
DESCRIPTION="Disable # CM_PRESS#/HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_PRESS#/HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A4"
{
DESCRIPTION="Disable # CM_PRESS#/HI_HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_PRESS#/HI_HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A5"
{
DESCRIPTION="Disable #CM_VSL_TMP_CTRL#/LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_VSL_TMP_CTRL#/LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A6"
{
DESCRIPTION="Disable #CM_VSL_TMP_CTRL#/LO_LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_VSL_TMP_CTRL#/LO_LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A7"
{
DESCRIPTION="Disable #CM_VSL_TMP_CTRL#/HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_VSL_TMP_CTRL#/HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A8"
{
DESCRIPTION="Disable #CM_VSL_TMP_CTRL#/HI_HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_VSL_TMP_CTRL#/HI_HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A9"
{
DESCRIPTION="Disable #CM_JKT_TMP_CTRL#/LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_JKT_TMP_CTRL#/LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A10"
{
DESCRIPTION="Disable #CM_JKT_TMP_CTRL#/LO_LO_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_JKT_TMP_CTRL#/LO_LO_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A11"
{
DESCRIPTION="Disable #CM_JKT_TMP_CTRL#/HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_JKT_TMP_CTRL#/HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A12"
{
DESCRIPTION="Disable #CM_JKT_TMP_CTRL#/HI_HI_ALM"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'//#CM_JKT_TMP_CTRL#/HI_HI_ENB' := False;"
DELAY_TIME=0
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
}
STEP NAME="S40"
{
DESCRIPTION="Complete"
RECTANGLE= { X=205 Y=600 H=40 W=120 }
ACTION NAME="A1"
{
DESCRIPTION="Wait for PH-ARB composite = Idle. Set PH-ARB/ARB_CMD = Release. Set PH-ARB composite to Start"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/FAIL_MONITOR/PH-ARB/ARB_CMD.CV' := 'PH-ARB_CMD:Release';
'^/FAIL_MONITOR/PH-ARB/COMMAND.CV' := '$sfc_commands:Start Sequence';"
DELAY_EXPRESSION="'^/FAIL_MONITOR/PH-ARB/STATE.CV' = '$sfc_states:Sequence Idle'"
CONFIRM_EXPRESSION="'^/FAIL_MONITOR/PH-ARB/STATE.CV' = '$sfc_states:Sequence Completed'"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A2"
{
DESCRIPTION="Wait for [1]. Clear Unit Message"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/P_MSG_PATH.CV' := """";
'^/P_MSG_PATH2.CV' := """";
'^/P_MSG_TYPE.CV' := 'MSG_TYPE:Information';
'^/P_MSG_TYPE2.CV' := 'MSG_TYPE:Information';
'^/P_MSG_OWNER.CV' := """";
'^/P_MSG_OWNER2.CV' := """";"
DELAY_EXPRESSION="'S40/A1/STATE.CV' = '$sfc_action_states:Complete'"
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
ACTION NAME="A3"
{
DESCRIPTION="Wait for [2]. Clear Dynamic References"
ACTION_TYPE=ASSIGN
QUALIFIER=P
EXPRESSION="'^/P_MSG_PATH.$REF' := """";
'^/P_MSG_TYPE.$REF' := """";
'^/P_MSG_OWNER.$REF' := """";
'^/P_MSG_PATH2.$REF' := """";
'^/P_MSG_TYPE2.$REF' := """";
'^/P_MSG_OWNER2.$REF' := """";
'//#THIS-UNIT#/U_SYNC_RD.$REF' := """" ;
'//#THIS-UNIT#/U_SYNC_MSG_RD.$REF' := """" ;"
DELAY_EXPRESSION="'S40/A2/STATE.CV' = '$sfc_action_states:Complete'"
CONFIRM_EXPRESSION="True"
CONFIRM_TIME_OUT=0
}
}
INITIAL_STEP="S0"
TRANSITION NAME="T0"
{
DESCRIPTION="Pass Through"
POSITION= { X=255 Y=138 }
TERMINATION=F
EXPRESSION="True"
}
TRANSITION NAME="T10"
{
DESCRIPTION="Wait for actions to complete"
POSITION= { X=255 Y=274 }
TERMINATION=F
EXPRESSION="'S10/PENDING_CONFIRMS' = 0"
}
TRANSITION NAME="T20"
{
DESCRIPTION="Wait for actions to complete"
POSITION= { X=255 Y=410 }
TERMINATION=F
EXPRESSION="'S20/PENDING_CONFIRMS' = 0"
}
TRANSITION NAME="T30"
{
DESCRIPTION="Wait for actions to complete"
POSITION= { X=255 Y=546 }
TERMINATION=F
EXPRESSION="'S30/PENDING_CONFIRMS' = 0"
}
TRANSITION NAME="T40"
{
DESCRIPTION="Abort complete"
POSITION= { X=255 Y=682 }
TERMINATION=T
EXPRESSION="'S40/PENDING_CONFIRMS.CV' = 0"
}
STEP_TRANSITION_CONNECTION STEP="S0" TRANSITION="T0" { }
STEP_TRANSITION_CONNECTION STEP="S10" TRANSITION="T10" { }
STEP_TRANSITION_CONNECTION STEP="S20" TRANSITION="T20" { }
STEP_TRANSITION_CONNECTION STEP="S30" TRANSITION="T30" { }
STEP_TRANSITION_CONNECTION STEP="S40" TRANSITION="T40" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0" STEP="S10" { }
TRANSITION_STEP_CONNECTION TRANSITION="T10" STEP="S20" { }
TRANSITION_STEP_CONNECTION TRANSITION="T20" STEP="S30" { }
TRANSITION_STEP_CONNECTION TRANSITION="T30" STEP="S40" { }
}

<tbody>
</tbody>
Click to expand...

And I want to parse it in to a table like this

Its not finished but you get the picture

StepActionDescription
S0

<tbody>
</tbody>
N/A

<tbody>
</tbody>
N/A

<tbody>
</tbody>
T0

<tbody>
</tbody>
T0

<tbody>
</tbody>
Pass Through

<tbody>
</tbody>
S10
A1

<tbody>
</tbody>
Set unit message to message 10

<tbody>
</tbody>
A2
Set Failure Devices Mask to 0

<tbody>
</tbody>
A3
Disable Process Failure Conditions

<tbody>
</tbody>
A4
If PH-ARB composite is active then set PH-ARB composite to stop

<tbody>
</tbody>
A5
Send Sync message 254 to Destination Unit

<tbody>
</tbody>
A6
Clear unit message 2

<tbody>
</tbody>
T10T10
Wait for actions to complete

<tbody>
</tbody>
S20
A1

<tbody>
</tbody>
Set #EM_INLET# to HOLD
A2Set #EM_PRESS# to HOLD

<tbody>
</tbody>
 
Last edited:
Sort by date Sort by votes
Also T9900A and T0040A is not listed under S0000 when I use your tool

STEP_TRANSITION_CONNECTION STEP="S0000" TRANSITION="T0010" { }
STEP_TRANSITION_CONNECTION STEP="S0000" TRANSITION="T0040A" { }
STEP_TRANSITION_CONNECTION STEP="S0000" TRANSITION="T9900A" { }
STEP_TRANSITION_CONNECTION STEP="S0010" TRANSITION="T0020A" { }
STEP_TRANSITION_CONNECTION STEP="S0020" TRANSITION="T0030" { }
STEP_TRANSITION_CONNECTION STEP="S0020" TRANSITION="T0040B" { }
STEP_TRANSITION_CONNECTION STEP="S0030" TRANSITION="T0020B" { }
STEP_TRANSITION_CONNECTION STEP="S0040" TRANSITION="T0050A" { }
STEP_TRANSITION_CONNECTION STEP="S0050" TRANSITION="T0060" { }
STEP_TRANSITION_CONNECTION STEP="S0050" TRANSITION="T0070" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0100" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0200A" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0300A" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0400A" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0500A" { }
STEP_TRANSITION_CONNECTION STEP="S0060" TRANSITION="T0600A" { }
STEP_TRANSITION_CONNECTION STEP="S0070" TRANSITION="T0050B" { }
STEP_TRANSITION_CONNECTION STEP="S0100" TRANSITION="T0110" { }
STEP_TRANSITION_CONNECTION STEP="S0110" TRANSITION="T0100B" { }
STEP_TRANSITION_CONNECTION STEP="S0110" TRANSITION="T0120" { }
STEP_TRANSITION_CONNECTION STEP="S0120" TRANSITION="T0130" { }
STEP_TRANSITION_CONNECTION STEP="S0120" TRANSITION="T0140A" { }
STEP_TRANSITION_CONNECTION STEP="S0130" TRANSITION="T0100C" { }
STEP_TRANSITION_CONNECTION STEP="S0130" TRANSITION="T0140B" { }
STEP_TRANSITION_CONNECTION STEP="S0140" TRANSITION="T0150" { }
STEP_TRANSITION_CONNECTION STEP="S0150" TRANSITION="T0160" { }
STEP_TRANSITION_CONNECTION STEP="S0160" TRANSITION="T0170" { }
STEP_TRANSITION_CONNECTION STEP="S0170" TRANSITION="T0180" { }
STEP_TRANSITION_CONNECTION STEP="S0180" TRANSITION="T0190" { }
STEP_TRANSITION_CONNECTION STEP="S0190" TRANSITION="T0200B" { }
STEP_TRANSITION_CONNECTION STEP="S0200" TRANSITION="T0205" { }
STEP_TRANSITION_CONNECTION STEP="S0205" TRANSITION="T0210" { }
STEP_TRANSITION_CONNECTION STEP="S0210" TRANSITION="T0220" { }
STEP_TRANSITION_CONNECTION STEP="S0220" TRANSITION="T0235A" { }
STEP_TRANSITION_CONNECTION STEP="S0220" TRANSITION="T0225A" { }
STEP_TRANSITION_CONNECTION STEP="S0225" TRANSITION="T0235B" { }
STEP_TRANSITION_CONNECTION STEP="S0225" TRANSITION="T0230" { }
STEP_TRANSITION_CONNECTION STEP="S0230" TRANSITION="T0225B" { }
STEP_TRANSITION_CONNECTION STEP="S0230" TRANSITION="T0235C" { }
STEP_TRANSITION_CONNECTION STEP="S0235" TRANSITION="T0240" { }
STEP_TRANSITION_CONNECTION STEP="S0235" TRANSITION="T0270" { }
STEP_TRANSITION_CONNECTION STEP="S0240" TRANSITION="T0250" { }
STEP_TRANSITION_CONNECTION STEP="S0250" TRANSITION="T0260" { }
STEP_TRANSITION_CONNECTION STEP="S0260" TRANSITION="T0500B" { }
STEP_TRANSITION_CONNECTION STEP="S0270" TRANSITION="T0280" { }
STEP_TRANSITION_CONNECTION STEP="S0280" TRANSITION="T0300B" { }
STEP_TRANSITION_CONNECTION STEP="S0300" TRANSITION="T0310" { }
STEP_TRANSITION_CONNECTION STEP="S0310" TRANSITION="T0320" { }
STEP_TRANSITION_CONNECTION STEP="S0320" TRANSITION="T0400B" { }
STEP_TRANSITION_CONNECTION STEP="S0400" TRANSITION="T0405" { }
STEP_TRANSITION_CONNECTION STEP="S0405" TRANSITION="T0410" { }
STEP_TRANSITION_CONNECTION STEP="S0410" TRANSITION="T0425A" { }
STEP_TRANSITION_CONNECTION STEP="S0410" TRANSITION="T0415A" { }
STEP_TRANSITION_CONNECTION STEP="S0415" TRANSITION="T0425B" { }
STEP_TRANSITION_CONNECTION STEP="S0415" TRANSITION="T0420" { }
STEP_TRANSITION_CONNECTION STEP="S0420" TRANSITION="T0225B1" { }
STEP_TRANSITION_CONNECTION STEP="S0420" TRANSITION="T0425C" { }
STEP_TRANSITION_CONNECTION STEP="S0425" TRANSITION="T0430" { }
STEP_TRANSITION_CONNECTION STEP="S0430" TRANSITION="T0440" { }
STEP_TRANSITION_CONNECTION STEP="S0440" TRANSITION="T0500C" { }
STEP_TRANSITION_CONNECTION STEP="S0500" TRANSITION="T0600B" { }
STEP_TRANSITION_CONNECTION STEP="S0600" TRANSITION="T0610" { }
STEP_TRANSITION_CONNECTION STEP="S0610" TRANSITION="T0620" { }
STEP_TRANSITION_CONNECTION STEP="S0620" TRANSITION="T0630" { }
STEP_TRANSITION_CONNECTION STEP="S0630" TRANSITION="T0640" { }
STEP_TRANSITION_CONNECTION STEP="S0640" TRANSITION="T9900B" { }
STEP_TRANSITION_CONNECTION STEP="S9900" TRANSITION="END" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0010" STEP="S0010" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0020A" STEP="S0020" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0020B" STEP="S0020" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=1041 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0030" STEP="S0030" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0040A" STEP="S0040" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0040B" STEP="S0040" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0050A" STEP="S0050" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0050B" STEP="S0050" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=1005 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0060" STEP="S0060" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0070" STEP="S0070" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0100" STEP="S0100" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0100B" STEP="S0100" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=966 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0100C" STEP="S0100" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=1014 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0110" STEP="S0110" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0120" STEP="S0120" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0130" STEP="S0130" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0140A" STEP="S0140" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0140B" STEP="S0140" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0150" STEP="S0150" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0160" STEP="S0160" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0170" STEP="S0170" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0180" STEP="S0180" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0190" STEP="S0190" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0200A" STEP="S0200" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0200B" STEP="S0200" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0205" STEP="S0205" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0210" STEP="S0210" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0220" STEP="S0220" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0225A" STEP="S0225" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0225B" STEP="S0225" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=1015 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0225B1" STEP="S0415" { SEGMENT { INDEX=2 ORIENTATION=VERTICAL ORDINATE=945 } }
TRANSITION_STEP_CONNECTION TRANSITION="T0230" STEP="S0230" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0235A" STEP="S0235" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0235B" STEP="S0235" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0235C" STEP="S0235" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0240" STEP="S0240" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0250" STEP="S0250" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0260" STEP="S0260" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0270" STEP="S0270" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0280" STEP="S0280" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0300A" STEP="S0300" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0300B" STEP="S0300" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0310" STEP="S0310" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0320" STEP="S0320" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0400A" STEP="S0400" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0400B" STEP="S0400" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0405" STEP="S0405" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0410" STEP="S0410" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0415A" STEP="S0415" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0420" STEP="S0420" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0425A" STEP="S0425" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0425B" STEP="S0425" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0425C" STEP="S0425" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0430" STEP="S0430" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0440" STEP="S0440" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0500A" STEP="S0500" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0500B" STEP="S0500" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0500C" STEP="S0500" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0600A" STEP="S0600" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0600B" STEP="S0600" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0610" STEP="S0610" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0620" STEP="S0620" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0630" STEP="S0630" { }
TRANSITION_STEP_CONNECTION TRANSITION="T0640" STEP="S0640" { }
TRANSITION_STEP_CONNECTION TRANSITION="T9900A" STEP="S9900" { }
TRANSITION_STEP_CONNECTION TRANSITION="T9900B" STEP="S9900" { }

<tbody>
</tbody>
 
Last edited:
Upvote 0

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Snaybot said:
Would it be possible to get the

"POSITION= {X= Y=}" for the transitions

And

"RECTANGLE= { X=812 Y=915 H=40 W=120 }" for steps
Click to expand...
Would this be
- a separate result table, or
- 2 extra columns on the existing result table**, or
- something else?

** If extra columns, what happens for steps that have multiple actions?
If extra columns then perhaps you could re-post the result table from post #1 with the extra information included so I can see the desired layout. Explain if any further merging is required.
 
Upvote 0
A different table would great!

Also did you figure out how to get multiple Transitions under the Steps? I tried playing around and I couldnt get it to work... its gonna be tricky
 
Upvote 0
I'm still confused.

1. Your second example results showed this:

Excel Workbook
ABC
1StepActionDescription
2S0000N/ANo Actions
Parsed Example 2



Yet the raw data contained this:

Excel Workbook
A
17132STEP NAME="S0000"
17133{
17134DESCRIPTION="Common Stop"
17135RECTANGLE= { X=49 Y=134 H=40 W=140 }
17136ACTION NAME="A0010"
17137{
17138DESCRIPTION="Display Message"
Raw Code 2



Why do your results show "No Actions" for Step S0000?



2. The raw data also contains this section:

Excel Workbook
A
13068STEP NAME="S0000"
13069{
13070DESCRIPTION="Start"
13071RECTANGLE= { X=595 Y=145 H=40 W=120 }
Raw Code 2


What rectangle values should be reported in the results for Step S0000, and why, given there are 2 different sets of rectangle values in the 2 Raw Code screen shots above?
 
Upvote 0


Everything past the:

"STEP_TRANSITION_CONNECTION STEP=
TRANSITION_STEP_CONNECTION TRANSITIONSTEP=

Step Cells A16999 and down can be ignored

<colgroup><col span="7"></colgroup><tbody>
</tbody>

<colgroup><col span="7"></colgroup><tbody>
</tbody>
 
Upvote 0
No, I'm afraid you have lost me so I'm not sure I'll be able to add anything more at this stage.
 
Upvote 0
You must log in or register to reply here.

Similar threads

zookeepertx
  • Question
Having trouble "deciphering" some code so I can see how it works
Replies
7
Views
92
zookeepertx
zookeepertx
L
  • Question
Help with VBA Code to Populate Another Worksheet
Replies
1
Views
921
aaewalsh
aaewalsh
H
  • Question
Vba Macro Code running partially when i trying it from another worksheet
Replies
3
Views
618
HaHoBe
HaHoBe
E
  • Solved
[VBA] File saving does not work/new version not uploaded
Replies
4
Views
503
NdNoviceHlp
NdNoviceHlp
J
  • Question
VBA Code for automated actionlog
2
Replies
13
Views
1K
JAZ91
J

Forum statistics

Threads
1,215,350
Messages
6,124,430
Members
449,158
Latest member
burk0007

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top