Hello - I am not a programmer but know some rudimentary commands to be able to fix Fox Pro files. My problem is I want to change a field's contents to be a fixed percentage of another field in the file. Field A = 5.00 so I want Field B to reflect 0.02 of Field A so 0.1.. I cannot use a replace command as I do not know how to phrase it so it correctly calculates. This is a file in an accounting program.
Would greatly appreciate assistance so I do not have to manually change 5,000 lines!