I've haven't done too much work with Functions. I often just use an include statement for the sake of modularity (but I don't feel that's good practice).
I would like to know why I am having problems with the following function. This function should take a parameter (QUOTE_ME) and add quotes in the right spots if they do not exist (in the case of strings). If quotes do exist then the input should match the output.
DEFINE FUNCTION QUOTEANATOR(QUOTE_ME/A1000)
QUOTE_ME = TRUNCATE(QUOTE_ME);
QUOTE_ME = STRREP (QUOTE_ME.LENGTH,QUOTE_ME,1,'''',0,'',1000,'A1000');
QUOTE_ME = TRUNCATE(QUOTE_ME);
QUOTE_ME = '''' || STRREP (QUOTE_ME.LENGTH,QUOTE_ME,4,' OR ',6,''' OR ''',1000,'A1000') || '''';
QUOTE_ME = TRUNCATE(QUOTE_ME);
QUOTEANATOR/A1000 = QUOTE_ME;
END
The error message I get is:
(FOC263) EXTERNAL FUNCTION OR LOAD MODULE NOT FOUND: TRUNCATE
Anyone know why TRUNCATE doesn't work? Am I making some syntax error? I've tried to put a - at the start of the lines, but that wasn't successful. I am using other Functions that I have created and used for a long time as templates, and they work fine.
Thanks again great community!This message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8201, SP 0.1, Windows 7, HTML
March 21, 2019, 03:55 PM
Waz
How about replacing TRUNCATE with RTRIM ?
Also, I don't like the reuse of fields especially without a format.