Does anyone know of an easy way for me to grab the current report name minus the .fex, so I can populate a variable with it?

For example; for report "MyReport.fex", I want to be able to grab "MyReport"

Thanks!

This message has been edited. Last edited by: Tim Bayer,

Hi
You may find this useful. You would have to place this in the code.
TABLE FILE MCTADJX
"&FOCFOCEXEC "
SUM KOUNT1
WHERE RECORDLIMIT IS 10
END

Hi
I am an old mainframer.
Try this for WebFOCUS. It works,just tested it
regards Steve
DEFINE FILE SQLOUT
NNAME/A16 ='&FOCFOCEXEC';
LEN/I6 = ARGLEN(16,NNAME,'I6');
NEWLEN/I6 = LEN-4; -* dont want .fex
NUMCHAR/I6 = (NEWLEN -2) +1;
NEWNAME/A16 = SUBSTR(16,NNAME,2,NEWLEN,NUMCHAR,'A16');
END
TABLE FILE SQLOUT
PRINT
fund_id asset_id CALEN_DT NEWNAME
HEADING doubleqquote NEWNAME with a less than sign goes in here doublequote

This message has been edited. Last edited by: Stefaans,

Tim,

If you're working with WF 7.6 and later, there's a newish variable &FOCFEXNAME that gives you the name of the fex without '.fex'. &FOCFOCEXEC has been providing an incorrect name since at least v5.3 days - it has an underscore at the front of the name.

Fex name: temporary123.fex
&FOCFEXNAME = temporary123
&FOCFOCEXEC = _temporary123

Try adding -? & to the top of your fex to list all the available variables at execution time.

This does not apply if you're running the fex via MRE - different variables are created.

(Please update your profile with the version of WebFOCUS you're working with.)

Francis, I tried your idea first because I was hoping it was as easy as a system defined variable. When I put the -? & at the top of my fex I get three variables back that contain the report name:

&FOCFEXNAME = MyReport.fex
&FOCFOCEXEC = _MyReport.fex
&FEX_NAME = MyReport.fex

The &FOCFEXNAME seems to also return .fex. I have not tried the other ideas yet, I will look at them now.

Thanks for the ideas.

  
-SET &ECHO=ALL;
-SET &FOC_FEXNAME = 'MyReport.fex';
-SET &FEX_OUT= GETTOK(&FOC_FEXNAME.EVAL, &FOC_FEXNAME.LENGTH, 1, '.', 20, 'A20');
-TYPE &FEX_OUT
-EXIT

Or

-SET &ECHO=ALL;
-SET &FOC_FEXNAME = 'MyReport.fex';

-SET &FEX_OUT= TRIM('T', '&FOC_FEXNAME.EVAL', &FOC_FEXNAME.LENGTH, '.fex', 4, 'A&FOC_FEXNAME.LENGTH');

-TYPE &FEX_OUT

Tom and Francis, both of those methods worked.

Thanks!