B
Brandon
I have a fixed length field file that I have imported into a table. I set the
field types to TEXT. There are several fields that have negative and positive
values that are represented by a non-numeric character in the last character
position in the field.
{ = 0
A = 1
B = 2
…
J = -1
K = -2
So, if the field value is "14J", it is actually "-141"
What is the easiest (most automated) way to go through the values of a field
and replace the values with numbers and a negative symbol where required?
I also have to place a decimal prior to the last two characters in some
fields. How can I get this done?
I appreciate any help in getting me on track.
-Brandon
field types to TEXT. There are several fields that have negative and positive
values that are represented by a non-numeric character in the last character
position in the field.
{ = 0
A = 1
B = 2
…
J = -1
K = -2
So, if the field value is "14J", it is actually "-141"
What is the easiest (most automated) way to go through the values of a field
and replace the values with numbers and a negative symbol where required?
I also have to place a decimal prior to the last two characters in some
fields. How can I get this done?
I appreciate any help in getting me on track.
-Brandon