Hi,
Can someone help me get past a problem?
I am using a script object that retrieves a list of workflows that should have active periods in Activities Window. To do that, the script makes use of a VARA.SQLI object. The values retrieved by the VARA are then included in a report:
:SET &HND2#=PREP_PROCESS_VAR(VARA.SQLI.PERIODS_REPORTS_2ND_CHECK)
:PROCESS &HND2#
: SET &RET2# = GET_PROCESS_LINE(&HND2#,1)
: PRINT "Check for extra/missing periods in Activities Window: &RET2#"
:ENDPROCESS
All good, but i need to remove the last character from the values retrieved and I could not find a way around this. As an example,the results of the script are added in a report and sent in an email as attachment but the output looks like this:
2018-02-19 10:03:09 - U00020408 Remove this period from Activities Window: JOBP.UC4_CHECK_BILLY
2018-02-19 10:03:09 - U00020408 Check the following missing periods in Activities Window:
JOBP.IN_WIP_ISSUE_RTN_INB_ERP_NSK_C4I basically want to get rid of the last character from the bolded value. This means that i would like to use a script function to remove that last character from
&RET2#For now I tried using
STR_CUT,MID,SUBSTR but with no results. Is there a simple way to achieve this?
Thank you!