Forum Discussion
Etherscan api
Great, that got me thinking on the right path, thank you! What I did was:
1- extract the first four digits from "value" column
2- count the characters in "value" column
3-divide first four digit column with a calculated column using IFs based on the character count to divide by 1xxxx (x being 0)
abujouz86 oh so you are getting scientific notation value, so it is converting to decimal correclty.
Scientific notation calculator - with step by step explanations (mathportal.org)
Great, that got me thinking on the right path, thank you! What I did was:
1- extract the first four digits from "value" column
2- count the characters in "value" column
3-divide first four digit column with a calculated column using IFs based on the character count to divide by 1xxxx (x being 0)