Idea Details

Enhance request: STRING and SUBSTRING functions - F63135

Last activity 11 days ago
Takashi Kinoshita's profile image
10-16-2017 01:54 AM

We want to use STRING and SUBSTRING functions in Easytrieve. Please consider it.


Comments

03-25-2019 07:16 AM

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 

09-05-2018 08:22 AM

Hi Takashi,

 

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:


Type
Example
Field Relational
   IF field-1 = field-2
Field Series
   IF field-1 = field-2, field-3, field-4
Field Class
   IF field-1 ALPHABETIC
Field Bits
   IF field-1 ON X'0F4000
File Presence
   IF EOF file-name
File Relational
   IF MATCHED file-1, file-2, file-3
Record Relational
   IF DUPLICATE file-name

 

Best Regards,
Keith Watts
CA Technologies, Inc

09-04-2018 08:56 PM

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.

 

Best Regards,

Takashi Marukawa

08-27-2018 09:25 AM

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 ?

 

Best Regards,
Keith Watts
CA Technologies, Inc

11-15-2017 07:22 PM

Hi Ken,

 

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.

Please consider it.

 

Best Regards,

Takashi

 

Takashi Marukawa

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

 

<mailto:Takashi.Marukawa@ca.com>[CA]<http://www.ca.com/us/default.aspx>[Twitter]<http://twitter.com/CAInc>[Slideshare]<http://www.slideshare.net/cainc>[Facebook]<https://www.facebook.com/CATechnologies>[YouTube]<http://www.youtube.com/user/catechnologies>[LinkedIn]<http://www.linkedin.com/company/1372?goback=.cps_1244823420724_1>[Google]<https://plus.google.com/CATechnologies>[blogs]<http://blogs.ca.com/>[Communities]<https://communities.ca.com/welcome>

11-13-2017 01:55 PM

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 = '??????'

         PERFORM SOMETHING

         SUB =76

    END-IF

    SUB = SUB + 1

END-DO

11-06-2017 12:31 PM

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?