MivaLearn
8/2/2023 - 10:24 PM

Get Last PO Description From pay_data

<mvt:comment> Set delimiter variables </mvt:comment>
<mvt:assign name="g.colon" value="':'" />
<mvt:assign name="g.comma" value="','" />
<mvt:assign name="g.equal" value="'='" />
<mvt:comment> First seperate string by the colon and add to an array </mvt:comment>
<mvt:do file="g.Module_Library_Utilities" name="l.null" value="SplitString( l.settings:order:pay_data, g.colon, l.settings:pay_data_array )" />
<mvt:comment> Loop through the array </mvt:comment>
<mvt:foreach iterator="data" array="pay_data_array">    
    <mvt:comment> check if descrip is in the iterator and if so use substring to get the data after the = sign which is 9 characters  </mvt:comment>
    <mvt:if expr="'descrip' CIN l.settings:data">
        <mvt:assign name="l.settings:po:descrip" value="substring(l.settings:data, 9, len(l.settings:data) )" />
        <mvt:assign name="l.settings:po:descrip" value="glosub(l.settings:po:descrip, '+', ' ')" />
        <mvt:assign name="l.settings:po:descrip" value="glosub(l.settings:po:descrip, ',', '')" />
        &mvt:po:descrip;
    </mvt:if>
</mvt:foreach>