Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Imbedded space issue in URL
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Imbedded space issue in URL
 Login/Join
 
Master
posted
So I have a report header with a hyperlink. It works if my URL path and file name have no spaces. It fails where there is a space...as is the case below. How do I adjust the syntax to account for the spaces?

TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=10,
SIZE=8,
COLOR=RGB(255 102 0),
TARGET='_blank',
URL=X:\DEPT\my reports\Dept Head List.PDF,

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
COMPUTE URLTXT/A150='X:\Main\my reports\D&|H\DeptHeadlst.PDF';
..........
TYPE=REPORT,
TARGET='_blank',
URL=(URLTXT),
$


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 414 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Master
posted Hide Post
Anyone, I tried single quotes around the path and double...no dice. This seems pretty basic, what am I doing wrong?


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Guru
posted Hide Post
did you try my suggestion at all?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 414 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Master
posted Hide Post
sorry - I missed it..not sure how. Where does this go in the fex..at the beginning? In a define, after the table statement?


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Master
posted Hide Post
if at the beginning, line 1, I get this:


0 ERROR AT OR NEAR LINE 1 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC001) THE NAME OF THE FILE OR THE WORD 'FILE' IS MISSING
0 ERROR AT OR NEAR LINE 13 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC324) THE PARAMETER TO BE SET IS NOT RECOGNIZED: RLSPACE
(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 144: URL=(URLTXT)


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Master
posted Hide Post
if I move the compute under my TABLE statement I get this error:


(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 70: URL=(URLTXT)


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Compute needs a TABLE FILE... SUM before it. Something like:
  
TABLE FILE CAR
SUM COMPUTE URLTXT/A150='C:\Downloads\Corporate file name.pdf'; NOPRINT 


WebFOCUS 8206, Unix, Windows
 
Posts: 1749 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
 
TABLE FILE CAR
PRINT 
COMPUTE URLTXT/A150 = 'X:\Main\my reports\D&|H\DeptHeadlst.PDF';
BY  MODEL

ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty,
$
TYPE=REPORT,
     URL=(URLTXT),
    TARGET='_blank',
$
ENDSTYLE
END
 


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 414 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Master
posted Hide Post
I tried the SET method and get this error; note I must use: |, when I use: || it errors out altogether.

ERROR AT OR NEAR LINE 11 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC324) THE PARAMETER TO BE SET IS NOT RECOGNIZED: RLSPACE
(FOC3202) BAD VALUE IN STYLESHEET FILE AT LINE 143: URL=(URLTXT2)


Using the compute now works but now I get the path value on every row printed...getting closer though...


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
Virtuoso
posted Hide Post
If you don't want to see the COMPUTE add a NOPRINT to the right of ;


WebFOCUS 8206, Unix, Windows
 
Posts: 1749 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Master
posted Hide Post
...made it a noprint...seems to work...thanks all!


WebFOCUS 8.
Windows, All Outputs
 
Posts: 550 | Registered: June 28, 2013Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Imbedded space issue in URL

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.