I have a file that contains a left justified numeric value (space filled to the right) in which I need to place a decimal in front of the last two digits. Normally, not an issue for me if the value count is consistent. However, the value count won't always be consistent.
This is an example of what the file looks like:
This is how I want it to look.
The starting position will always start in the same position (16) every time and the next field will always start in the same position (25).
I'm looking for a way to add the decimals without having manually do it since this file could have a few hundred rows at a time.
Any help is appreciated.
This is an example of what the file looks like:
Code: Select all
ABC123456789XYZ20045 XYZ
ABC123456789XYZ100065 XYZ
ABC123456789XYZ4563326 XYZ
Code: Select all
ABC123456789XYZ200.45 XYZ
ABC123456789XYZ1000.65 XYZ
ABC123456789XYZ45633.26 XYZ
I'm looking for a way to add the decimals without having manually do it since this file could have a few hundred rows at a time.
Any help is appreciated.