I’m a newbie, but looking to do the following.
I have a pipe-delimited file with several records in the following format:
A|B| | |1234566789|ABC
I need to find a way to copy each individual line of the file to multiple new lines in a new file while replacing the last value in the line.
Output file for the line above would be:
A|B| | |1234566789|NEWVALUE1
A|B| | |1234566789|NEWVALUE2
A|B| | |1234566789|NEWVALUE3
A|B| | |1234566789|NEWVALUE4
Any help would be greatly appreciated.