We want to use STRING and SUBSTRING functions in Easytrieve. Please consider it.
Thank you for submitting this idea. The product team has reviewed this idea and determined that because of other priorities it will not be implemented at this time.
We greatly value your contributions to our community and are committed to continued engagement with you to improve our products.
Voting is now closed, however a new idea can be opened in the future to revisit if there is high demand for this need. Please let us know if you have any immediate questions.
CA Technologies – A Broadcom Company Advisor, Product Management
CA Deutschland GmbH | Marienburgstraße 35 | 64297 Darmstadt
Thank you for updating this information.
You are requesting a capability that is significantly different from currently supported syntax capabilities. We will consider this request accordingly.
The language reference manual identifies each type of conditional expression used in an IF statement:
TypeExampleField Relational IF field-1 = field-2Field Series IF field-1 = field-2, field-3, field-4Field Class IF field-1 ALPHABETICField Bits IF field-1 ON X'0F4000File Presence IF EOF file-nameFile Relational IF MATCHED file-1, file-2, file-3Record Relational IF DUPLICATE file-name
Best Regards,Keith WattsCA Technologies, Inc
Hi Keith, Thank you very much for your comment.
I understand the $STRING macro does the same kind of thing, but our customers want to use it as a function, like IF SUBSTR(field(X,Y)) = 'ABC'.
Please consider it.
I understand the need for a SUBSTRING capability.
Could you clarify the STRING capability that you want ?
There is a %STRING macro provided with PanAuditPlus. Is that what you want ?
Thank you very much for your sample.
We understand we can do similar thing with the macro or index, however our customers want to have them as functions of Easytrieve.
Principal Consultant, Presales
CA Technologies | 2-7-9, Hirakawacho, Chiyoda-ku JA Kyosai Building 8th and 9th floor | Tokyo, 13 102-0093
Office: +45231 | Mobile: +81 80 5409 1363 | Takashi.Marukawa@ca.com
Here is an example of one way to search for a string of characters which is I believe you want the SUBSTRING command to do.Could also be done with an index.
data -in 1 80 A
in-data 1 1 A OCCURS 80
SUB W 2 B
HOLD-STRING W 6 A
JOB INPUT XXXXXXXX
SUB = 1
* THIS WILL SEARCH FOR A STRING OF 6 CHARACTERS
DO WHILE SUB LT 75
MOVE IN-DATA(SUB) 6 TO HOLD-STRING
IF HOLD-STRING = '??????'
SUB = SUB + 1
Check in the maclib provided by CA and see if the CONCAT macro is there. It acts like a STRING function. Not sure about the SUBSTRING you are asking for. Can you provide more details about SUBSTRING?