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 , October 27, 2010 12:00 PM 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