Focal Point
[CLOSED] Slicing URL

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/784105555

October 20, 2010, 03:01 PM
Krishna.edara
[CLOSED] Slicing URL
Hi All,
Is their any way to get the text(showing Red Colour) between 'ex=' and '&' in the bellow URL.
example:
MEDICAL=%24*&IBIF_ex=ISSUSRC2&C2=OR+%28ORG_NAM_TST

Thanks,
Krish.

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


WebFocus-8/Windows/HTML, PDF, EXCEL
October 20, 2010, 04:01 PM
Prarie
Take a look at this
October 20, 2010, 05:41 PM
Waz
Here is an option that will work with HTML and PDF.

It uses the MARKUP stylesheet option.

DEFINE FILE CAR
 TEXT/A100  = 'MEDICAL=%24*&|IBIF_ex=ISSUSRC2&|C2=OR+%28ORG_NAM_TST' ;
 POS1/I9    = POSIT(TEXT, 100, 'ex=', 3,POS1) + 2 ;
 PART1/A100V = SUBSTR(100, TEXT, 1, POS1, POS1, PART1) ;
 REST1/A100V = SUBSTR(100, TEXT, POS1+1, 100, 100, REST1) ;
 POS2/I9    = POSIT(REST1, 100, '&', 1,POS2)-1 ;
 PART2/A100V = SUBSTR(100, REST1, 1, POS2, POS2, PART2) ;
 PART3/A100V = SUBSTR(100, REST1, POS2+1, 100, 100, PART3) ;
 MU_TEXT/A100V = PART1 || '<font color=#FF0000>' || PART2 || '</font>' || PART3 ;
END
TABLE FILE CAR
PRINT TEXT
OVER  MU_TEXT
BY COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1
-*ON TABLE PCHOLD FORMAT HTML
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
 MARKUP=ON, $
ENDSTYLE
END



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!