I have a file that is generated from a system automatically and within the file it has financial figures with a decimal point in.
The file produces the value £56.40
I need the file to produce the figure as 0000000000000005640
The file produces the value £31.43
I need the file to produce the figure as 0000000000000003143
So if the value is a whole number it drops the zero of the end.
If the value is not a round number it inserts a decimal point and requires an additional zero before the value.
The figure will always start from column line 2 and 50 spaces in and end at 68 spaces in.
The file could have 100s of lines.
I need a batch file to edit this file automatically.
Any help would be appreciated. It need to a windows bat file not PowerShell.
I have attached the file.