converting binary to decimal

[Luca Berardi]

we have a txt file which contains a column of binary data, this is an example
0111001
10010
1101
1000100
we import this data as a txt file and we want to obtain the corresponding decimal value for each row in another column.
111001 = 57
10010 = 18
1101 = 13
1000100 = 68

How can we do that in FlexPro?
best regards

[Luca Berardi]

we have a txt file which contains a column of binary data, this is an example
0111001
10010
1101
1000100
we import this data as a txt file and we want to obtain the corresponding decimal value for each row in another column.
111001 = 57
10010 = 18
1101 = 13
1000100 = 68

How can we do that in FlexPro?
best regards

[Bernhard Kantz]

This FPScript code runs under FlexPro 7:

dim b = { 101, 110, 0 } // Example binary data series
Dim d = 0. # NumberOfRows(b) // Result decimal data series
Dim n = 8 // Maximum number of bits to convert
For i = 0 To n – 1 Do
d = d + (b & 1) * 2 ^ i
b = b / 10
End
Return d

[Author]

Posts