how to remove the last charater of the variable?

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

July 14, 2008, 01:47 PM

j.gross

That will remove all instances.

To delete just the final non-blank character you can use ARGLEN (to determine its position) and SUBSTR.

- Jack Gross
WF through 8.1.05

July 14, 2008, 02:02 PM

Gobinath Velusamy

Hi

I cant determine the length ... i t will vary dynamically

WebFOCUS 7610
Windows

July 14, 2008, 02:19 PM

j.gross

Are these dialog manager & variables, or Focus fields? If the latter, are they fixed or variable in length?

- Jack Gross
WF through 8.1.05

July 14, 2008, 02:27 PM

GinnyJakes

There is a REVERSE subroutine. You can flip the contents, check to see if the firt character is a comma, remove it, then flip it back.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

July 14, 2008, 02:31 PM

krishkasi

Hi Gopinath,
Can you try this below?

-SET &TEST = 'All,1,2,3,';
-SET &TEST1 = SUBSTR(&TEST.LENGTH, &TEST, 1, &TEST.LENGTH-1, &TEST.LENGTH-1, 'A&TEST.LENGTH');
-TYPE &TEST1

Regards,
Kasi Krishnan
WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000.
OS: Windows & AIX

July 15, 2008, 04:05 AM

Danny-SRL

Gobinath,

I think you can use TRIM:

  
-* File strip1.fex
-SET &ST='A1,A2,A34,';
-SET &STL=&ST.LENGTH;
-SET &STM=TRIM('T','&ST.EVAL',&STL,',',1,'A&STL.EVAL');
-TYPE &ST : &STM

However, if the ',' is not the last character in your string and you have trailing blanks, then you should also r-justify your string:

  
-SET &ST='A1,A22,A3425,    ';
-SET &STL=&ST.LENGTH;
-SET &STM=LJUST(&STL, TRIM('T',RJUST(&STL,'&ST.EVAL','A&STL.EVAL'),&STL,',',1,'A&STL.EVAL'),'A&STL.EVAL');
-TYPE &ST : &STM

This message has been edited. Last edited by: Danny-SRL,

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