Is this possible via sort (in one pass)?

chillmo · New User Joined: 31 Aug 2017 Posts: 39 Location: USA

I have a file with multiple record types in position 26 (PD, length=2), e.g., 0, 10, 11, 15, 20, 25, etc., however, if position 25 is "Y" for record type 0, I need to change the date in position 30 of record type 10, to current date (CCYY-MM-DD).

I'm able to accomplish this in two passes but wanted to know if it can be done in one pass?

any assistance or guidance would be greatly appreciated!

Joerg.Findeisen · Posted: Sat Oct 26, 2024 10:18 am

You have not provided sample data, nor shared info whether the records are sorted by type and such. Depended on that, I would chose a strategy.

chillmo · New User Joined: 31 Aug 2017 Posts: 39 Location: USA

Yes, the final output record will be sorted by record type and account, ascending order, and I included sample data below:

Joerg.Findeisen · Posted: Tue Oct 29, 2024 8:16 am

Try this snippet:

chillmo · New User Joined: 31 Aug 2017 Posts: 39 Location: USA

Joerg.Fineisen, as usual, it worked like a charm.

The business changed their requirement from current date to first of the month, so I modified the code below: