J
Juan Valdez
[[ This message was both posted and mailed: see
the "To," "Cc," and "Newsgroups" headers for details. ]]
I have the following data:
00000000000976042B
00000000000637707{
00000000000016326{
00000000000047546F
00000000001484392E
00000000000687370E
00000000000958500{
00000000000771160{
00000000004424795A
The last character of each row requires translation as follows:
{=0
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
I'm able to translate the 18th character by using the replace function
but would like a less manual process. I'm a bit outside the box at the
moment and not sure to go from here. Could sure use some help! Thank
you!
the "To," "Cc," and "Newsgroups" headers for details. ]]
I have the following data:
00000000000976042B
00000000000637707{
00000000000016326{
00000000000047546F
00000000001484392E
00000000000687370E
00000000000958500{
00000000000771160{
00000000004424795A
The last character of each row requires translation as follows:
{=0
A=1
B=2
C=3
D=4
E=5
F=6
G=7
H=8
I=9
I'm able to translate the 18th character by using the replace function
but would like a less manual process. I'm a bit outside the box at the
moment and not sure to go from here. Could sure use some help! Thank
you!