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.