I don't have a clue on how to do this. I have excel, powershell, and ultraedit available on my pc.
I have a text file populated with multiple variable in a fixed width layout.
the logic I need to produce is.
if columns 19 - 27 are blank, then please insert the value of columns 319 - 227 into columns 19 - 27.
obviously if there is a value in 19 - 27 then I don't want it to be edited.
is there a way I can do this. the file is a .txt