Hi I am having an issue with a txt file. I need to edit it so that any time the file sees 16,451 it replaces that to 16,475
Additionally I need to replace the underlined 0 with the bolded numbers.
I am having problems because sometimes that data is all in one line and sometimes it is in two lines.
Once I've figured out a way to do this, I need to do it to 220 files. Any and all help is much appreciated.
Original File:
16,451,13039,,42,0,PAY PAY SERVICE REF*CK*6416*Peoples Gas
49,2460
98,24607
02,104
03,13100
16,451,16228,,42,0/
88,PAY PAY SERVICE REF*CK*6414*Commonwealth Edison
16,451,123750,,42,0/
88,PAY PAY SERVICE REF*CK*6415*Leasing
49,2799
98,27995
What I need:
16,475,13039,,42,6416,PAY PAY SERVICE REF*CK*6416*Peoples Gas
49,2460
98,24607
02,104
03,13100
16,475,16228,,42,6414/
88,PAY PAY SERVICE REF*CK*6414*Commonwealth Edison
16,475,123750,,42,6415/
88,PAY PAY SERVICE REF*CK*6415*Leasing
49,2799
98,27995
What I have tried:
I've tried some smaller things, but nothing I know of is working.