Need a help how to replace a string in REXX based on cnditio

gurunath82 · New User Joined: 26 Jul 2016 Posts: 4 Location: INDIA

Hi,

I am new to REXX . Based on Forums i built a new CLIST panel and i am passing /accessing the values from the panel. My inputs are bank name, input string and replacing string.

My input file strucure is like below

PRIN AAAAAAAAAAAAAAAAA CITI 11111111111
CUTOFF TIME 01:00
CITY NAME : NEWYORK
PRIN AAAAAAAAAAAAAAAAA ICIC 222222
CUTOFF TIME 02:00
CITY NAME : NEWYORK

My requirement is I want to check whether ACRO is matching which received from the panel, if matches i want to replace the string which i received from the panel.

Ex: From panel ACRO : ICIC, CITY NAME: NEW JERSY

So exactly for ICIC the CITY name should change in the file. Other should remain same.

Expected output:

PRIN AAAAAAAAAAAAAAAAA CITI 11111111111
CUTOFF TIME 01:00
CITY NAME : NEWYORK
PRIN AAAAAAAAAAAAAAAAA ICIC 222222
CUTOFF TIME 02:00
CITY NAME : NEWJERSY

My ACRO( Bank Name) is in position 40 and every time bank name should start with PRIN.( Firt 4 charters).

It would be great if any one can reply with code. We tired all possible ways but no luck, for updating the file.( need to check PRIN in first 4 positions and also acro name, if acro matches i want to replace the string).

Appreciate your help on this.

Thank you.

Pedro · Posted: Wed Jul 27, 2016 12:52 am

Akatsukami · Posted: Wed Jul 27, 2016 12:54 am

Your post has one major technical error (there is no such thing as a CLIST panel) and one major rules violation (you did not use Code tags to format your data). Moreover, you have committed the enormity of asking for code without offering payment. PM me and I will explain how you can exchange Rs, 6,000 for the solution.

Rohit Umarjikar · Posted: Wed Jul 27, 2016 1:19 am

Welcome!!
Is that what you want?
if Bank Name = 'ICIC' then some Rexx function to overlay CITY NAME with the input value else do nothing?

gurunath82 · New User Joined: 26 Jul 2016 Posts: 4 Location: INDIA

YES Rohit.

The Bank name is 40 position. When ever the Bank name matches i have to overlay the CITY NAME.

Thanks for looking into it.

gurunath82 · New User Joined: 26 Jul 2016 Posts: 4 Location: INDIA

As per my requirement, Under bank name there may 30 to 40 fields, Some times i may get requirement like change the cutoff name or chnage the city name, change the country name...etc. That's why i went to replace/overlay the string.

It would be great if any one share the code based on condition ( particular position Field matches), need to overlay the next matching string if not matches, we can just display the like string not found and come out of the loop.( no need to update the file).

I am sorry, Unfortunately i am not able to share my code, because of security issues.

PeterHolland · Posted: Wed Jul 27, 2016 11:20 am

Pedro · Posted: Wed Jul 27, 2016 9:41 pm

Rohit Umarjikar · Posted: Wed Jul 27, 2016 9:48 pm

prino · Posted: Wed Jul 27, 2016 9:53 pm

Pedro · Posted: Thu Jul 28, 2016 12:00 am

gurunath82 · New User Joined: 26 Jul 2016 Posts: 4 Location: INDIA

Thanks All.

I got this. Thanks Rohit, i also got same thought in my mind and i implemented this on Wednesday. In Rexx Manuals, i found sub string concept. I read current record and used substring function to check first 4 bytes and 40 to 4 bytes, if my condition is matching i set a flag to Y. Again continued reading each record when ever my input string is matches for the exact position and FALG=Y. If both are satisfied i replaced the string and set flag "N".

Thanks all once again your suggestions. .

Rohit Umarjikar · Posted: Fri Jul 29, 2016 10:48 am

very good. let us know if you face any more issues also see how trace works so as to debug yourself.