Is there a Calc formula to count total decimal and whole digits?

[canunca]

Hi everyone! I wanted to ask, is there a LibreCalc function that counts how many fractional digit are there in a number, and also one that counts the whole digits? I found a .csv file I want to make a database for, and I want to find out the proper max data type length I need.

Thank you for the help.

Version: 24.2.3.2 (x86) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

[Villeroy]

@canunca

I want to make a database for, and I want to find out the proper max data type length I need.

Why not test with MAX and MIN?

[canunca]

@fpy

=LEN(MyTextualNumber) - FIND(DecimalSeparator; MyTextualNumber)

Yeah I tried those. LEN(MAX()) works with whole numbers. With decimals it counts every digit and the . char. Wanted to check if there was a way without it becoming a bus length formula.

Thanks for the help.

[fpy]

=LEN(MyTextualNumber) - FIND(DecimalSeparator; MyTextualNumber)

more details and options from this post :

How do you calculate the number of digits after a decimal point

Generally numbers are actually represented in LibrOffice in a dyadic format name IEEE 754 Double. Since this representation is not decimal, there is no “number of digits after the decimal separator” defined. What you see is only made for the visualization, often by applying a format code. If a numeric result is rounded to a specific number of decimals like in =ROUND(MyResult; 3) the number in the second parameter position is the number of decimal places. If you actually have text looking like …

[canunca]

Thanks. Managed to get something working with that.