Focal Point
[SOLVED] help with substr (amper variables)

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

June 12, 2008, 11:19 AM
Tomsweb
[SOLVED] help with substr (amper variables)
Can anyone help me get the &XP2 line to work?

-*************************************
-* CONVERT STRING WITH ODD CHARACTERS
-*************************************
-SET &ECHO=ALL;
-*
-TYPE .
-SET &CATEGORY = 'TRAIN/EX';
-TYPE CATEGORY = &CATEGORY
-*
-SET &NL = ARGLEN(&CATEGORY.LENGTH,&CATEGORY,'I2');
-TYPE LENGTH = &NL
-*
-SET &XP = POSIT(&CATEGORY, 6, '/', 1, 'I1');
-TYPE '/' IS FOUND IN POSITION: &XP
-*
-SET &XP1 = SUBSTR(6,&CATEGORY, 1, &XP,&XP-1,'A5');
-TYPE &XP1
-*
-SET &XP2 = SUBSTR(6,&CATEGORY,(&XP+1),(&XP+2), 2,'A2');
-TYPE &XP2
-GOTO OUTT

-SET &XCATEGORY = &XP1 | &XP2;
-*
-TYPE CATEGORY = &XCATEGORY
-*
-*
-OUTT
-EXIT

Thanks Red Face

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


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
June 12, 2008, 11:50 AM
Kamesh
Are you getting any error?


WFConsultant

WF 8105M on Win7/Tomcat
June 12, 2008, 11:55 AM
Kamesh
Isn't the length of Category is 8?

Try this,

-SET &ECHO='ALL';

-*************************************
-* CONVERT STRING WITH ODD CHARACTERS
-*************************************
-*
-TYPE .
-SET &CATEGORY = 'TRAIN/EX';
-TYPE CATEGORY = &CATEGORY
-*
-SET &NL = ARGLEN(&CATEGORY.LENGTH,&CATEGORY,'I2');
-TYPE LENGTH = &NL
-*
-SET &XP = POSIT(&CATEGORY, &NL, '/', 1, 'I1');
-TYPE '/' IS FOUND IN POSITION: &XP
-*
-SET &XP1 = SUBSTR(&NL,&CATEGORY, 1, &XP,&XP-1,'A5');
-TYPE &XP1
-*
-SET &XP2 = SUBSTR(&NL,&CATEGORY,(&XP+1),(&XP+2), 2,'A2');
-TYPE &XP2
-GOTO OUTT

-SET &XCATEGORY = &XP1 | &XP2;
-*
-TYPE CATEGORY = &XCATEGORY
-*
-*
-OUTT
-EXIT


WFConsultant

WF 8105M on Win7/Tomcat
June 12, 2008, 12:14 PM
Danny-SRL
Tom,
Do you just want to get rid of the '/'?
If so, use STRIP
  
-SET &CATEGORY = 'TRAIN/EX';
-SET &CATLEN=&CATEGORY.LENGTH;
-SET &XCATEGORY=STRIP(&CATLEN, &CATEGORY, '/', 'A&CATLEN.EVAL');



Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

June 12, 2008, 01:01 PM
Tomsweb
quote:
-SET &CATEGORY = 'TRAIN/EX';
-SET &CATLEN=&CATEGORY.LENGTH;
-SET &XCATEGORY=STRIP(&CATLEN, &CATEGORY, '/', 'A&CATLEN.EVAL');


Thanks...I did not think of strip...like it more as it is less coding.


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36