 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 8 matches |
| Author | Message |
|---|---|
 Topic: DFSORT yield rate calculation |
|
| nachiyappan Replies: 2 Views: 3178 |
 Forum: Utilities Posted: Mon Mar 01, 2021 2:04 pm Subject: DFSORT yield rate calculation |
| Hi Kolusu,
Thanks for your quick reply. For example of 5% interest rate, the yield rate is 5.12675. Both interest rate and yield rate are PD . COBOL definition for both is PIC S9(03)V9(05) COMP-3. ( ... |
|
| Topic: DFSORT yield rate calculation |
|
| nachiyappan Replies: 2 Views: 3178 |
Forum: Utilities Posted: Sun Feb 28, 2021 11:08 pm Subject: DFSORT yield rate calculation |
| Hi, I have interest rate in a file in a fixed position. Is it possible to get the yield rate using DFSORT by performing the following formula
Yield rate = (((((interest rate / 100 ) / 365) + 1)^3 ... |
|
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Thu Sep 10, 2020 1:41 pm Subject: Find replace duplicate apostrophe in a varying length string |
| Hi Kolusu,
In fact, I tried this already and really glad that this worked out. The work which may span into multiple days of development definitely shortened because of your help. Thank you very mu ... |
|
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Thu Sep 10, 2020 9:11 am Subject: Find replace duplicate apostrophe in a varying length string |
| Hi Kolusu, for the example I provided , this approach worked really well. Thank a lot for providing this valuable solution. I have another challenge. If any fields are blank in the subsequent records, ... | |
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Tue Sep 08, 2020 4:05 pm Subject: Find replace duplicate apostrophe in a varying length string |
| Hi Kolusu, Awesome, I can understand the logic , will try this and let you know the outcome. Thanks a lot !! | |
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Tue Sep 08, 2020 3:19 pm Subject: Find replace duplicate apostrophe in a varying length string |
| Hi Kolusu, There are only 11 fields.
"'ABC,DEF'" is one field and is a name field with first and last name separated by a comma. The comma in there is not part of the CSV formatting ... |
|
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Tue Sep 08, 2020 1:11 pm Subject: Find replace duplicate apostrophe in a varying length string |
| Thanks Srihari Kolusu very much. The inner double quotes are not always followed by a space, or in other words there is no known pattern. If I had to write a COBOL code, the my logic would be to take ... | |
| Topic: Find replace duplicate apostrophe in a varying length string |
|
| nachiyappan Replies: 9 Views: 7053 |
Forum: Utilities Posted: Tue Sep 08, 2020 12:09 pm Subject: Find replace duplicate apostrophe in a varying length string |
| Need help. There is a need to replace duplicate double quotes (apostrophe) in a varying length string in a FB file having LRECL as 133. Here's the example
Input: 05,09082020,1234536666,"'ABC,D ... |
|
All times are GMT - 5 Hours |